Table: engine_specs_8
Columns: name
volume
engine
fuel
output
torque
engine_id_code_s
0_100km_h_s
top_speed
years

Question: What engine has an output of ps (kw; hp) @4700 rpm?
SQL: SELECT "engine" FROM engine_specs_8 WHERE "output" = 'ps (kw; hp) @4700 rpm'

Question: What is the output of the engine AEX/APQ that uses petrol?
SQL: SELECT "output" FROM engine_specs_8 WHERE "fuel" = 'petrol' AND "engine_id_code_s" = 'aex/apq'

Question: What is the 0–100km/h,s for the output of ps (kw; hp) @4000 rpm?
SQL: SELECT COUNT("0_100km_h_s") FROM engine_specs_8 WHERE "output" = 'ps (kw; hp) @4000 rpm'