CREATE TABLE table_65666 ("Name" CLOB, "Gain" FLOAT, "Loss" FLOAT, "Long" FLOAT, "Avg/G" FLOAT)

How many losses have jake sharp as the name, with a long less than 30?
SELECT COUNT("Loss") FROM table_65666 WHERE "Name" = 'jake sharp' AND "Long" < '30'
SELECT COUNT("Loss") FROM "table_65666" WHERE "Long" < '30' AND "Name" = 'jake sharp'