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 era a dupla mista que tinha jogadoras mulheres de maria gomes zamy gomes, e jogadores homens de fernando silva ricardo fernandes?
 ###Tabelas: CREATE TABLE senate_composition_as_a_result_of_the_elections (senate_composition_as_a_result_of_the_elections_id AUTO_INCREMENT PRIMARY KEY, D 50 O VARCHAR, D 49 √ VARCHAR, D 48 √ VARCHAR, D 47 √ VARCHAR, D 46 √ VARCHAR, D 45 √ VARCHAR, D 44 √ VARCHAR, D 43 √ VARCHAR, D 42 √ VARCHAR, D 41 √ VARCHAR) CREATE TABLE final_table (final_table_id AUTO_INCREMENT PRIMARY KEY, Position INT, Club VARCHAR, Played INT, Points VARCHAR, Wins INT, Draws INT, Losses INT, Goals for INT, Goals against INT, Goal Difference INT) CREATE TABLE past_winners (past_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, Men's singles VARCHAR, Women's singles VARCHAR, Men's doubles VARCHAR, Women's doubles VARCHAR, Mixed doubles VARCHAR) CREATE TABLE stage_casts (stage_casts_id AUTO_INCREMENT PRIMARY KEY, Productions VARCHAR, Rose VARCHAR, Louise VARCHAR, Dainty June VARCHAR, Herbie VARCHAR, Director VARCHAR) CREATE TABLE season_4_1998 (season_4_1998_id AUTO_INCREMENT PRIMARY KEY, Series # INT, Season # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production code VARCHAR)  
SELECT Mixed doubles FROM past_winners WHERE Women's doubles = maria gomes zamy gomes AND Men's doubles = fernando silva ricardo fernandes