CREATE TABLE table_42705 ("Rank" CLOB, "Country" CLOB, "Wins" FLOAT, "Winners" FLOAT, "First title" FLOAT, "Last title" FLOAT)

Which First title has Wins smaller than 8 and in Canada?
SELECT COUNT("First title") FROM table_42705 WHERE "Wins" < '8' AND "Country" = 'canada'
SELECT COUNT("First title") FROM "table_42705" WHERE "Country" = 'canada' AND "Wins" < '8'