CREATE TABLE table_31899 ("Rank" FLOAT, "Name" CLOB, "Team" CLOB, "Goals" FLOAT, "Appearances" FLOAT)

How many appearances were made by people that had 5 goals and less than 7 rank?
SELECT COUNT("Appearances") FROM table_31899 WHERE "Goals" = '5' AND "Rank" < '7'
SELECT COUNT("Appearances") FROM "table_31899" WHERE "Goals" = '5' AND "Rank" < '7'