Table: bmw_3_series_compact
Columns: model
years
engine_code
power
torque

Question: During which years was the Model 318td (diesel) with the Engine code of m47d20 manufactured?
SQL: SELECT "years" FROM bmw_3_series_compact WHERE "engine_code" = 'm47d20' AND "model" = '318td (diesel)'

Question: What is the Torque of the model with the engine code of M54B25?
SQL: SELECT "torque" FROM bmw_3_series_compact WHERE "engine_code" = 'm54b25'

Question: What is the Torque of the Model 320td (diesel)?
SQL: SELECT "torque" FROM bmw_3_series_compact WHERE "model" = '320td (diesel)'

Question: During which years was the model with the Engine code of m54b25 manufactured?
SQL: SELECT "years" FROM bmw_3_series_compact WHERE "engine_code" = 'm54b25'

Question: Which model was made from 2001–2004, with a Torque of n·m (lb·ft) @ 3750, and an Engine code of n42b18 / n46b18?
SQL: SELECT "model" FROM bmw_3_series_compact WHERE "years" = '2001–2004' AND "torque" = 'n·m (lb·ft) @ 3750' AND "engine_code" = 'n42b18 / n46b18'