Table: vehicle_specs
Columns: model_type
model_designation
engine
wheelbase_mm_inch
gvw_kg_ton
axle_ratio

Question: How many different engines are there for the model with model designation 97G00?
SQL: SELECT COUNT("engine") FROM vehicle_specs WHERE "model_designation" = '97G00'

Question: What's the engine for the model model designation 97G00 and GVW of 2500/2.46 kg/ton?
SQL: SELECT "engine" FROM vehicle_specs WHERE "gvw_kg_ton" = '2500/2.46' AND "model_designation" = '97G00'

Question: What model type has model designation 97500?
SQL: SELECT "model_type" FROM vehicle_specs WHERE "model_designation" = '97500'

Question: What's the axle ratio of the model with model designation 97G00?
SQL: SELECT "axle_ratio" FROM vehicle_specs WHERE "model_designation" = '97G00'

Question: What model type has 97100 model designation?
SQL: SELECT "model_type" FROM vehicle_specs WHERE "model_designation" = '97100'