Table: fuel_econ_uk_2008
Columns: manufacturer
model
transmission
engine_capacity
fuel_type
l_100km_urban_cold
l_100km_extra_urban
l_100km_combined
mpg_uk_urban_cold
mpg_uk_extra_urban
mpg_uk_combined
mpg_us_urban
mpg_us_extra_urban
mpg_us_combined
co_2_g_km
green_rating

Question: What is the total engine capacity of the a4 transmission, which has an urban mpg-US greater than 19, an mpg-us extra-urban greater than 38.6, and an aveo model?
SQL: SELECT COUNT("engine_capacity") FROM fuel_econ_uk_2008 WHERE "transmission" = 'a4' AND "mpg_us_urban" > 19 AND "mpg_us_extra_urban" > 38.6 AND "model" = 'aveo'

Question: What is the highest engine capacity with a bmw manufacturer, an mpg-UK extra-urban of 52.3, a 176 CO 2 g/km, and an mpg-us urban greater than 27.3?
SQL: SELECT MAX("engine_capacity") FROM fuel_econ_uk_2008 WHERE "manufacturer" = 'bmw' AND "mpg_uk_extra_urban" = 52.3 AND "co_2_g_km" = 176 AND "mpg_us_urban" > 27.3

Question: What is the mpg-uk combined with an mpg-uk urban (cold) greater than 26.6, a m5 transmission, a diesel fuel type, and an engine capacity less than 1560?
SQL: SELECT "mpg_uk_combined" FROM fuel_econ_uk_2008 WHERE "mpg_uk_urban_cold" > 26.6 AND "transmission" = 'm5' AND "fuel_type" = 'diesel' AND "engine_capacity" < 1560

Question: What is the l/100km urban (cold) with a CO 2 g/km less than 222, an mpg-us urban greater than 17.8, an mpg-uk extra-urban of 55.4, and an engine capacity greater than 1560?
SQL: SELECT "l_100km_urban_cold" FROM fuel_econ_uk_2008 WHERE "co_2_g_km" < 222 AND "mpg_us_urban" > 17.8 AND "mpg_uk_extra_urban" = 55.4 AND "engine_capacity" > 1560

Question: What model has a g green rating, has chrysler jeep as a manufacturer, has an l/100km urban (cold) less than 18, and has an mpg-uk combined of 27.7?
SQL: SELECT "model" FROM fuel_econ_uk_2008 WHERE "green_rating" = 'g' AND "manufacturer" = 'chrysler jeep' AND "l_100km_urban_cold" < 18 AND "mpg_uk_combined" = 27.7