CREATE TABLE table_name_91 (manufacturer VARCHAR, rider VARCHAR)

Who is the manufacturer of the car driven by Bradley Smith?
SELECT manufacturer FROM table_name_91 WHERE rider = "bradley smith"
SELECT "manufacturer" FROM "table_name_91" WHERE "bradley smith" = "rider"