human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Matches, Player, Lost, Drawn, Tied
###Question: Tell me the lost with tie of 0 and drawn of 47
gpt
SELECT Lost FROM table WHERE Tied = 0 AND Drawn = 47