Schema: CREATE TABLE table_name_24 (result VARCHAR, field VARCHAR, date VARCHAR)
Question: What is the result of the game at Bishop Kearney Field on August 2?
SQL: SELECT result FROM table_name_24 WHERE field = "bishop kearney field" AND date = "august 2"