How many wins did West Ham get when Millwall had more than 23 goal and 5 wins, and they tied 8 times?
CREATE TABLE table_name_56 (west_ham_wins VARCHAR, drawn VARCHAR, millwall_wins VARCHAR, millwall_goals VARCHAR)
SELECT west_ham_wins FROM table_name_56 WHERE millwall_wins > 5 AND millwall_goals > 23 AND drawn = 8
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_56 (west_ham_wins VARCHAR, drawn VARCHAR, millwall_wins VARCHAR, millwall_goals VARCHAR) Question: How many wins did West Ham get when Millwall had more than 23 goal and 5 wins, and they tied 8 times? [/INST] SELECT west_ham_wins FROM table_name_56 WHERE millwall_wins > 5 AND millwall_goals > 23 AND drawn = 8 </s>