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: Quais foram os resultados do torneio masculino quando as Sydney Scorpions derrotaram as Hunter Hornets no torneio feminino de 40 anos?
 ###Tabelas: CREATE TABLE nfl_professionals (nfl_professionals_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Position VARCHAR, Height VARCHAR, Weight(lbs) INT, Born VARCHAR, College VARCHAR, Drafted VARCHAR) CREATE TABLE results_by_year (results_by_year_id AUTO_INCREMENT PRIMARY KEY, Year INT, Mens Open VARCHAR, Womens Open VARCHAR, Mixed Open VARCHAR, Mens u20 VARCHAR, Womens u20 VARCHAR, Senior Mixed VARCHAR, Mens 30 VARCHAR, Womens 30 VARCHAR, Mens 35 VARCHAR, Womens 35 VARCHAR, Mens 40 VARCHAR, Womens 40 VARCHAR, Mens 45 VARCHAR, Mens 50 VARCHAR) CREATE TABLE season_1:_2003–2004 (season_1:_2003–2004_id AUTO_INCREMENT PRIMARY KEY, Series # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production code INT) CREATE TABLE 8000+_meters (8000+_meters_id AUTO_INCREMENT PRIMARY KEY, World Rank INT, Rank (Pakistan) INT, Name VARCHAR, Height (m) INT, Location VARCHAR) CREATE TABLE first_team (first_team_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Pos. VARCHAR, Player VARCHAR, From club VARCHAR, Transfer fee VARCHAR)  
SELECT Mens Open FROM results_by_year WHERE Womens 40 = Sydney Scorpions defeated Hunter Hornets