CREATE TABLE table_name_23 (location_attendance VARCHAR2, record VARCHAR2)

what is the location/attendance when the record is 9-2?
SELECT location_attendance FROM table_name_23 WHERE record = "9-2"
SELECT "location_attendance" FROM "table_name_23" WHERE "9-2" = "record"