lab6-CARS-results

lab6-CARS-results - Citroen citroen ds-21 pallas 3090 hi hi...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
SQL> start lab6 NUM_JAPANESE_CARS ----------------- 7 NUM_JAPANESE_CARS ----------------- 79 NUM_FORD_CARS ------------- 3 NUM_FORD_CARS ------------- 65 AVG(D.MPG) ---------- 24.24 NAME AVG(D.MPG) AVG(D.ACCELERATE) AVG(D.EDISPL) -------------------- ---------- ----------------- ------------- usa 17.55 16.35 253.4 japan 27.5 16 110.25 germany 25.6666667 15.1666667 98.3333333 france 23 17 120 sweden 23.5 14 121 NAME -------------------- japan MODEL YEAR ACCELERATE --------------- ---------- ---------- plymouth 1970 8 ford 1970 8 MODEL YEAR NAME --------------- ---------- -------------------- oldsmobile 1981 usa FULLNAME MAKE WEIGHT ------------------------- ------------------------------------------------------------ ----------
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Citroen citroen ds-21 pallas 3090 hi hi 1200d 4732 Chrysler dodge monaco (sw) 4955 General Motors pontiac safari (sw) 5140 Ford Motor Company mercury marquis brougham 4952 American Motor Company amc matador (sw) 4257 Opel opel manta 2300 Honda honda civic 2489 Subaru subaru 2391 Fiat fiat 131 2464 Toyota toyota mark ii 2930 Daimler Benz mercedes-benz 280s 3820 BMW bmw 320i 2600 Mazda mazda rx-4 2720 Peugeaut peugeot 604sl 3410 Volkswagen audi 5000s (diesel) 2950 Triumph triumph tr7 coupe 2500 Renault renault 18i 2320 Saab saab 900s 2800 Volvo volvo diesel 3160 Nissan Motors datsun 810 maxima 2930 21 rows selected. NAME COUNT(*) -------------------- ---------- japan 14 usa 3 germany 4 sweden 8 france 1 SQL> spool off...
View Full Document

This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.

Page1 / 2

lab6-CARS-results - Citroen citroen ds-21 pallas 3090 hi hi...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online