user: Question: Tell me the lost with tie of 0 and drawn of 47
Columns: ['Matches', 'Player', 'Lost', 'Drawn', 'Tied']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['247', 'Colin Cowdrey', '61', '104', '0']
SQL:

assistant: SELECT "Lost" FROM "Table" WHERE "Tied" = '0' AND "Drawn" = '47';