CREATE TABLE table_name_47 (lost NUMBER, points VARCHAR2, drawn VARCHAR2)

Which Lost has Points of 28 and a Drawn smaller than 8?
SELECT AVG(lost) FROM table_name_47 WHERE points = 28 AND drawn < 8
SELECT AVG("lost") FROM "table_name_47" WHERE "drawn" < 8 AND "points" = 28