CREATE TABLE table_name_20 (lost VARCHAR2, tied VARCHAR2, drawn VARCHAR2)

Tell me the lost with tie of 0 and drawn of 47
SELECT lost FROM table_name_20 WHERE tied = "0" AND drawn = "47"
SELECT "lost" FROM "table_name_20" WHERE "0" = "tied" AND "47" = "drawn"