Table: kent_cricketers
Columns: matches
player
lost
drawn
tied

Question: Tell me the lost with tie of 0 and drawn of 47
SQL: SELECT "lost" FROM kent_cricketers WHERE "tied" = '0' AND "drawn" = '47'

Question: Name the tie that has 71 drawn
SQL: SELECT "tied" FROM kent_cricketers WHERE "drawn" = '71'

Question: I want to know the drawn that has a tie of 0 and the player is chris cowdrey
SQL: SELECT "drawn" FROM kent_cricketers WHERE "tied" = '0' AND "player" = 'chris cowdrey'

Question: I want to know the tie for drawn of 47
SQL: SELECT "tied" FROM kent_cricketers WHERE "drawn" = '47'