Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quantas vitórias o West Ham obteve quando o Millwall teve mais de 23 gols e 5 vitórias, e eles empataram 8 vezes?
 ###Tabelas: CREATE TABLE player_stats (player_stats_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Games Played INT, Minutes INT, Field Goals INT, Three Pointers INT, Free Throws INT, Rebounds INT, Assists INT, Blocks INT, Steals INT, Points INT) CREATE TABLE record_by_competition (record_by_competition_id AUTO_INCREMENT PRIMARY KEY, Competition VARCHAR, Played INT, Millwall wins INT, Drawn INT, West Ham wins INT, Millwall goals INT, West Ham goals INT) CREATE TABLE 40_point_games (40_point_games_id AUTO_INCREMENT PRIMARY KEY, Number INT, Opponent VARCHAR, Box Score VARCHAR, Points INT, FGM - FGA VARCHAR, 3PM - 3PA VARCHAR, FTM - FTA VARCHAR, Assists INT, Rebounds INT, Steals INT, Blocks INT) CREATE TABLE top_5_winners (top_5_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, Putri Pariwisata Indonesia VARCHAR, 1st Runner Up VARCHAR, 2nd Runner Up VARCHAR, 3rd Runner Up VARCHAR, 4th Runner Up VARCHAR) CREATE TABLE 1914–1925 (1914–1925_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Born-Died VARCHAR, Term start VARCHAR, Term end VARCHAR, Political Party VARCHAR)  
SELECT West Ham wins FROM record_by_competition WHERE Millwall wins > 5 AND Millwall goals > 23 AND Drawn = 8