Table: bmw_m57_engine_specs
Columns: engine_code
displacement
power_torque_rpm
redline_rpm
year

Question: What is the displacement of the engine that has a Redline rpm higher than 4750, from 2005?
SQL: SELECT "displacement" FROM bmw_m57_engine_specs WHERE "redline_rpm" > 4750 AND "year" = 2005

Question: From what year is the engine with engine code M57D30?
SQL: SELECT "year" FROM bmw_m57_engine_specs WHERE "engine_code" = 'm57d30'

Question: What is the average Redline RPM of engines with engine code M57TUD30, made after 2002?
SQL: SELECT AVG("redline_rpm") FROM bmw_m57_engine_specs WHERE "engine_code" = 'm57tud30' AND "year" > 2002