Table: bmw_m47_engine_specs
Columns: engine
displacement
power
torque
year

Question: How powerful is the model before 1999?
SQL: SELECT "power" FROM bmw_m47_engine_specs WHERE "year" < 1999

Question: What displacement is the model in 1999 with a Torque of 280n·m (207lb·ft) @ 1750?
SQL: SELECT "displacement" FROM bmw_m47_engine_specs WHERE "year" = 1999 AND "torque" = '280n·m (207lb·ft) @ 1750'

Question: When is the earliest year with a Power of 90kw (121hp) @ 4000?
SQL: SELECT MIN("year") FROM bmw_m47_engine_specs WHERE "power" = '90kw (121hp) @ 4000'

Question: When is the earliest year with a Torque of 330n·m (243lb·ft) @ 2000-2500?
SQL: SELECT MIN("year") FROM bmw_m47_engine_specs WHERE "torque" = '330n·m (243lb·ft) @ 2000-2500'