Which Goals have a Club of hallelujah fc, and a Rank of 7?
CREATE TABLE table_name_78 (goals INTEGER, club VARCHAR, rank VARCHAR)
SELECT SUM(goals) FROM table_name_78 WHERE club = "hallelujah fc" AND rank = "7"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (goals INTEGER, club VARCHAR, rank VARCHAR) Question: Which Goals have a Club of hallelujah fc, and a Rank of 7? [/INST] SELECT SUM(goals) FROM table_name_78 WHERE club = "hallelujah fc" AND rank = "7" </s>