Table: carisma_specs
Columns: model
engine
displacement
valvetrain
fuel_system
max_power_at_rpm
max_torque_at_rpm
years

Question: What fuel system does the diesel engines model have?
SQL: SELECT "fuel_system" FROM carisma_specs WHERE "model" = 'diesel engines'

Question: What is the displacement for the petrol engines model?
SQL: SELECT "displacement" FROM carisma_specs WHERE "model" = 'petrol engines'