CREATE TABLE table_15297 ("First game" FLOAT, "Played" FLOAT, "Drawn" FLOAT, "Lost" FLOAT, "Percentage" CLOB)

how many times is there more than 0 draws and more than 0 losses?
SELECT COUNT("Played") FROM table_15297 WHERE "Drawn" > '0' AND "Lost" > '0'
SELECT COUNT("Played") FROM "table_15297" WHERE "Drawn" > '0' AND "Lost" > '0'