CREATE TABLE table_38824 ("Make/ Model" CLOB, "Length" CLOB, "Year" FLOAT, "Numbers  ( Quantity Ordered ) " CLOB, "Fuel Propulsion" CLOB, "Year Retired" CLOB)

For the year 1975, what is Propulsion, with a Number (quantity ordered) of 4756-4788 (33 buses)?
SELECT "Fuel Propulsion" FROM table_38824 WHERE "Year" = '1975' AND "Numbers (Quantity Ordered)" = '4756-4788 (33 buses)'
SELECT "Fuel Propulsion" FROM "table_38824" WHERE "Numbers (Quantity Ordered)" = '4756-4788 (33 buses)' AND "Year" = '1975'