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 ------------------------- ------------------------------------------------------------ ---------- 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