CREATE TABLE table_name_24 (constructor VARCHAR2, location VARCHAR2)

Who was the Long Beach constructor?
SELECT constructor FROM table_name_24 WHERE location = "long beach"
SELECT "constructor" FROM "table_name_24" WHERE "location" = "long beach"