CREATE TABLE table_name_42 (rank INT, goals VARCHAR, matches VARCHAR)

Which Rank has a Goals smaller than 76, and a Matches larger than 270?
SELECT SUM(rank) FROM table_name_42 WHERE goals < 76 AND matches > 270
SELECT SUM("rank") FROM "table_name_42" WHERE "goals" < 76 AND "matches" > 270