carData_databasePractice

carData_databasePractice - Model AcuraIntegra AcuraLegendV6...

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

View Full Document Right Arrow Icon
Model Country Type Weight Turning Circle Displacement Horsepower Gas Tank Size Task 1 Count the number of cars made in Japan Acura Integra Japan Smal 2700 37 112 130 13.2 Acura Legend V6 Japan Medium 3265 42 163 160 18 Countif 30 Audi 100 Other Medium 2935 39 141 130 21.1 Audi 80 Other Compact 2670 35 121 108 15.9 Audi 90 Other Compact 2790 35 141 130 15.9 BMW 325i Other Compact 2895 35 152 168 16.4 BMW 535i Other Medium 3640 39 209 208 21.1 Buick Century USA Medium 2880 41 151 110 15.7 Task 2 Count the number of cars that are small  Buick Electra V6 USA Large 3350 43 231 165 18 Buick Le Sabre V6 USA Large 3325 42 231 165 18 Count 22 Buick Riviera V6 USA Medium 3465 41 231 165 18.8 Buick Skylark USA Compact 2640 39 151 110 13.6 Cadil ac Brougham V8 USA Large 4285 44 307 140 25 Cadil ac De Vil e V8 USA Large 3545 43 273 180 18 Cadil ac Eldorado V8 USA Medium 3480 42 273 180 18.8 Chevrolet Astro V6 USA Large 4025 42 262 150 27 Task 3 Count the number of cars whose gas tank size > 17 gallons Chevrolet Beretta USA Compact 2655 38 133 95 15.6 Chevrolet Camaro V6 USA Sporty 3110 41 191 140 15.5 Count Chevrolet Camaro V8 USA Sporty 3320 41 305 170 15.5 Chevrolet Caprice V8 USA Large 3855 42 305 170 25 Chevrolet Cavalier USA Compact 2485 38 133 95 13.6 Chevrolet Corvette V8 USA Sporty 3280 42 350 250 20 Chevrolet Lumina USA Medium 3195 42 151 110 17.1 Chevrolet Lumina APV V6 USA Large 3630 42 191 120 20 Chrysler Imperial V6 USA Medium 3570 43 202 150 16 Chrysler Le Baron Coupe USA Medium 2975 39 153 150 14 Chrysler Le Baron V6 USA Compact 3065 41 181 141 16 Chrysler New Yorker V6 USA Medium 3450 42 202 147 16 Dodge Caravan USA Large 3385 42 153 100 20 Dodge Colt Japan Smal 2270 32 90 81 13.2 Dodge Daytona USA Sporty 2885 38 153 100 14 Dodge Daytona Turbo USA Sporty 2935 38 135 150 14 Dodge Dynasty USA Medium 3080 42 153 100 16 Dodge Grand Caravan V6 USA Large 3735 47 202 150 20 Dodge Omni USA Smal 2300 40 135 93 13 Dodge Shadow Turbo USA Compact 2670 38 153 150 14 Eagle Premier V6 USA Medium 3145 39 180 150 17 Eagle Summit USA Smal 2560 36 97 113 13.2 Eagle Talon USA Sporty 2780 39 122 135 15.9 Ford Aerostar V6 USA Large 3665 42 182 145 21 Ford Escort USA Smal 2345 37 114 90 13 Ford Festiva Other Smal 1845 33 81 63 10 Ford LTD Crown Victoria V8 USA Large 3850 45 302 150 18 Ford Mustang USA Sporty 2850 40 140 88 15.4 Ford Mustang V8 USA Sporty 3310 44 302 225 15.4 Ford Probe USA Sporty 2695 38 133 110 15.1 Ford Probe GT USA Sporty 2870 38 133 145 15.1 Ford Taurus USA Medium 3015 42 153 90 16 Ford Taurus V6 USA Medium 3190 41 182 140 16 Ford Tempo USA Compact 2750 39 141
Background image of page 1

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

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

Page1 / 2

carData_databasePractice - Model AcuraIntegra AcuraLegendV6...

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