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: Quem ganhou o duplas mistas no mesmo ano em que Andrew Downes ganhou o simples masculino?
 ###Tabelas: CREATE TABLE broadcasting (broadcasting_id AUTO_INCREMENT PRIMARY KEY, Small season number INT, Time of broadcast VARCHAR, Days of the week VARCHAR, Hours VARCHAR, Length of episode VARCHAR, Picture format VARCHAR) CREATE TABLE listing (listing_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Population ( 2011 Census ) INT, Percent of national population VARCHAR, % growth (2006–11) VARCHAR, Land area (km²) INT, Population density (/km 2 ) INT, House of Commons seats INT, House of Commons seats (%) VARCHAR, 2013 population (July est.) INT) CREATE TABLE ifl_champions (ifl_champions_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Champion VARCHAR, Runner Up VARCHAR, Israel Bowl VARCHAR, Venue VARCHAR, Date VARCHAR, Finals MVP VARCHAR) CREATE TABLE series_10 (series_10_id AUTO_INCREMENT PRIMARY KEY, Episode VARCHAR, First aired VARCHAR, Entrepreneur(s) VARCHAR, Company or product name VARCHAR, Money requested (£) VARCHAR, Investing Dragon(s) VARCHAR) CREATE TABLE previous_winners (previous_winners_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Men's singles VARCHAR, Women's singles VARCHAR, Men's doubles VARCHAR, Women's doubles VARCHAR, Mixed doubles VARCHAR)  
SELECT Mixed doubles FROM previous_winners WHERE Men's singles = andrew downes