SCHEMA:
CREATE TABLE table_name_97 (l_100km_urban__cold_ INTEGER, mpg_us_combined VARCHAR, l_100km_combined VARCHAR, l_100km_extra_urban VARCHAR, mpg_uk_combined VARCHAR)
User Question:
What is the average L/100km urban value having an L/100km extraurban under 7.2, mpg combined in the UK under 39.8, l/100km combined over 7.9, and mpg combined in the US under 25.1?


SELECT AVG(l_100km_urban__cold_) FROM table_name_97 WHERE l_100km_extra_urban < 7.2 AND mpg_uk_combined < 39.8 AND l_100km_combined > 7.9 AND mpg_us_combined < 25.1