CREATE TABLE table_79710 ("Rank" CLOB, "Nation" CLOB, "Gold" FLOAT, "Silver" FLOAT, "Bronze" FLOAT, "Total" FLOAT)

How many golds have 3 as the rank, with a total greater than 7?
SELECT COUNT("Gold") FROM table_79710 WHERE "Rank" = '3' AND "Total" > '7'
SELECT COUNT("Gold") FROM "table_79710" WHERE "Rank" = '3' AND "Total" > '7'