CREATE TABLE table_name_78 (goals INT, club VARCHAR, rank VARCHAR)

Which Goals have a Club of hallelujah fc, and a Rank of 7?
SELECT SUM(goals) FROM table_name_78 WHERE club = "hallelujah fc" AND rank = "7"
SELECT SUM("goals") FROM "table_name_78" WHERE "7" = "rank" AND "club" = "hallelujah fc"