CREATE TABLE table_name_1 (lost VARCHAR, played INT)

How many lost stats have a played number of less than 8?
SELECT COUNT(lost) FROM table_name_1 WHERE played < 8
SELECT COUNT("lost") FROM "table_name_1" WHERE "played" < 8