CREATE TABLE table_name_8 (record VARCHAR, date VARCHAR)

Which record has a Date of august 28?
SELECT record FROM table_name_8 WHERE date = "august 28"
SELECT "record" FROM "table_name_8" WHERE "august 28" = "date"