CREATE TABLE table_23970 ("Model Type" CLOB, "Model Designation" CLOB, "Engine" CLOB, "Wheelbase  ( mm/inch ) " CLOB, "GVW  ( kg/ton ) " CLOB, "Axle Ratio" CLOB)

How many different engines are there for the model with model designation 97G00?
SELECT COUNT("Engine") FROM table_23970 WHERE "Model Designation" = '97G00'
SELECT COUNT("Engine") FROM "table_23970" WHERE "Model Designation" = '97G00'