CREATE TABLE table_name_47 (record VARCHAR2, date VARCHAR2)

What is the Record with a Date with 24 march 2008?
SELECT record FROM table_name_47 WHERE date = "24 march 2008"
SELECT "record" FROM "table_name_47" WHERE "24 march 2008" = "date"