CREATE TABLE table_name_24 (result VARCHAR, field VARCHAR, date VARCHAR)

What is the result of the game at Bishop Kearney Field on August 2?
SELECT result FROM table_name_24 WHERE field = "bishop kearney field" AND date = "august 2"
SELECT "result" FROM "table_name_24" WHERE "august 2" = "date" AND "bishop kearney field" = "field"