CREATE TABLE table_41789 ("Rank" FLOAT, "Name" TEXT, "Years" TEXT, "Matches" FLOAT, "Goals" FLOAT)

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