CREATE TABLE table_name_41 (player VARCHAR, no_result VARCHAR, tied VARCHAR)

Which player has no 0 results and multiples ties?
SELECT player FROM table_name_41 WHERE no_result = 0 AND tied > 0
SELECT "player" FROM "table_name_41" WHERE "no_result" = 0 AND "tied" > 0