CREATE TABLE table_6907 ("Name" CLOB, "Years" CLOB, "Tests" FLOAT, "Drew" FLOAT, "Lost" FLOAT, "Win percentage" CLOB)

What is the total number of Tests when the lost is less than 9 for sir fred allen?
SELECT COUNT("Tests") FROM table_6907 WHERE "Lost" < '9' AND "Name" = 'sir fred allen'
SELECT COUNT("Tests") FROM "table_6907" WHERE "Lost" < '9' AND "Name" = 'sir fred allen'