Below is the list of tables from the database along with their columns and datatype. Need to generate an accurate SQL query for the question.
Only use the columns present in the respective table. Only use the columns which are required to generate the SQL query. Only use table joins if required and not otherwise.

### Tables ###
TABLE: CREATE TABLE table_name_12 (engine VARCHAR, transmission VARCHAR, acceleration_0_100km_h__0_62mph_ VARCHAR)

### Question ###
What is the engine when the transmission was 4-speed automatic, and acceleration 0–100km/h (0–62mph) was 10.4 s?

### Accurate SQL ###

SELECT engine FROM table_name_12 WHERE transmission = "4-speed automatic" AND acceleration_0_100km_h__0_62mph_ = "10.4 s"