CREATE TABLE table_name_25 (engine_capacity NUMBER, mpg_us_urban VARCHAR2, co_2_g_km VARCHAR2, manufacturer VARCHAR2, mpg_uk_extra_urban VARCHAR2)

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?
SELECT MAX(engine_capacity) FROM table_name_25 WHERE manufacturer = "bmw" AND mpg_uk_extra_urban = 52.3 AND co_2_g_km = 176 AND mpg_us_urban > 27.3
SELECT MAX("engine_capacity") FROM "table_name_25" WHERE "bmw" = "manufacturer" AND "co_2_g_km" = 176 AND "mpg_uk_extra_urban" = 52.3 AND "mpg_us_urban" > 27.3