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: Qual Men's 35 tem um Women's Open dos cobras da cidade de Brisbane def hornets ocidentais?
 ###Tabelas: CREATE TABLE number_of_championships_by_school (number_of_championships_by_school_id AUTO_INCREMENT PRIMARY KEY, University VARCHAR, Men's INT, Women's INT, Runner-up INT, Total Championships INT) CREATE TABLE western_conference_semifinals (western_conference_semifinals_id AUTO_INCREMENT PRIMARY KEY, Game VARCHAR, Date VARCHAR, Home team VARCHAR, Result VARCHAR, Road team VARCHAR) CREATE TABLE results_by_year (results_by_year_id AUTO_INCREMENT PRIMARY KEY, Year INT, Men's Open VARCHAR, Women's Open VARCHAR, Mixed Open VARCHAR, Men's u20 VARCHAR, Women's u20 VARCHAR, Senior Mixed VARCHAR, Men's 30 VARCHAR, Women's 30 VARCHAR, Men's 35 VARCHAR, Women's 35 VARCHAR, Men's 40 VARCHAR, Women's 40 VARCHAR, Men's 45 VARCHAR, Men's 50 VARCHAR) CREATE TABLE finishing_order (finishing_order_id AUTO_INCREMENT PRIMARY KEY, Position VARCHAR, Name VARCHAR, Jockey VARCHAR, Age INT, Weight (st, lb) VARCHAR, Starting price VARCHAR, Distance VARCHAR) CREATE TABLE standard_parameters (standard_parameters_id AUTO_INCREMENT PRIMARY KEY, Region VARCHAR, Start datum VARCHAR, Target datum VARCHAR, c_x ( Metre ) VARCHAR, c_y (Metre) VARCHAR, c_z (Metre) VARCHAR, s ( ppm ) VARCHAR, r x ( Arcsecond ) VARCHAR, r y ( Arcsecond ) VARCHAR, r z ( Arcsecond ) VARCHAR)  
SELECT Men's 35 FROM results_by_year WHERE Women's Open = brisbane city cobras def hunter western hornets