CREATE TABLE table_name_42 (crowd NUMBER, venue VARCHAR2)

How many people attended the game at Lake Oval?
SELECT SUM(crowd) FROM table_name_42 WHERE venue = "lake oval"
SELECT SUM("crowd") FROM "table_name_42" WHERE "lake oval" = "venue"