CREATE TABLE table_name_37 (apps NUMBER, name VARCHAR2)

What is the total of apps for Keith Treacy?
SELECT SUM(apps) FROM table_name_37 WHERE name = "keith treacy"
SELECT SUM("apps") FROM "table_name_37" WHERE "keith treacy" = "name"