Which player has no 0 results and multiples ties?
CREATE TABLE table_name_41 (player VARCHAR, no_result VARCHAR, tied VARCHAR)
SELECT player FROM table_name_41 WHERE no_result = 0 AND tied > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_41 (player VARCHAR, no_result VARCHAR, tied VARCHAR) Question: Which player has no 0 results and multiples ties? [/INST] SELECT player FROM table_name_41 WHERE no_result = 0 AND tied > 0 </s>