CREATE TABLE table_name_97 (location VARCHAR2, event VARCHAR2)

What's the location of the National event?
SELECT location FROM table_name_97 WHERE event = "the national"
SELECT "location" FROM "table_name_97" WHERE "event" = "the national"