user: ### NOW ANSWER:
Question: Which player has no 0 results and multiples ties?
Columns: ['Player', 'Dates of captaincy', 'Lost', 'Tied', 'No result', '% win [A ]']
Types: ['text', 'text', 'real', 'real', 'real', 'real']
Sample row: ['Alan Lewis Category:Articles with hCards', '1993/94', 4.0, 0.0, 0.0, 42.86]
SQL:

assistant: SELECT "Player" FROM "Table" WHERE "No result" = 0.0 AND "Tied" > 0.0;