Table: fuel_econ_uk_2008_2
Columns: manufacturer
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's the average L/km combines when the L/100km Urban is 13.9, the mpg-UK combined is more than 28.5 and the mpg-UK extra urban is less than 38.7?
SQL: SELECT AVG("l_100km_combined") FROM fuel_econ_uk_2008_2 WHERE "l_100km_urban_cold" = 13.9 AND "mpg_uk_combined" > 28.5 AND "mpg_uk_extra_urban" < 38.7

Question: What's the least mpg-UK combined when the mpg-UK urban is 25.4, the L/100km extra urban is less than 6.9 and the L/100km urban is more than 11.1?
SQL: SELECT MIN("mpg_uk_combined") FROM fuel_econ_uk_2008_2 WHERE "mpg_uk_urban_cold" = 25.4 AND "l_100km_extra_urban" < 6.9 AND "l_100km_urban_cold" > 11.1

Question: What's the CO2 g/km of a Fiat running on diesel with the L/100km urban more than 6.3 and an mpg-UK combined of 43.5?
SQL: SELECT COUNT("co_2_g_km") FROM fuel_econ_uk_2008_2 WHERE "fuel_type" = 'diesel' AND "manufacturer" = 'fiat' AND "l_100km_urban_cold" > 6.3 AND "mpg_uk_combined" = 43.5

Question: What's the total L/100km extra urban fueled by diesel, when the mpg-UK combines is more than 19.2, mpg-US is less than 50 and the L/100m combined is less than 5.7?
SQL: SELECT COUNT("l_100km_extra_urban") FROM fuel_econ_uk_2008_2 WHERE "mpg_uk_combined" > 19.2 AND "l_100km_combined" < 5.7 AND "fuel_type" = 'diesel' AND "mpg_us_combined" < 50

Question: What's the engine capacity when the mpg-UK urban is less than 12.2, the mpg-UK extra urban is less than 18.8 and the mpg-US turban is less than 7.2?
SQL: SELECT SUM("engine_capacity") FROM fuel_econ_uk_2008_2 WHERE "mpg_uk_urban_cold" < 12.2 AND "mpg_uk_extra_urban" < 18.8 AND "mpg_us_urban" < 7.2

Question: What's the mpg-US urban when the mpg-UK urban is 20 and the mpg-UK extra urban is less than 37.2?
SQL: SELECT SUM("mpg_us_urban") FROM fuel_econ_uk_2008_2 WHERE "mpg_uk_urban_cold" = 20 AND "mpg_uk_extra_urban" < 37.2