CREATE TABLE table_name_31 (class VARCHAR2, vehicle VARCHAR2, year VARCHAR2)

Which class had a vehicle of Nissan in 2007?
SELECT class FROM table_name_31 WHERE vehicle = "nissan" AND year = 2007
SELECT "class" FROM "table_name_31" WHERE "nissan" = "vehicle" AND "year" = 2007