CREATE TABLE table_name_44 (record VARCHAR2, date VARCHAR2)

What was the record on April 1?
SELECT record FROM table_name_44 WHERE date = "april 1"
SELECT "record" FROM "table_name_44" WHERE "april 1" = "date"