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 duplas mistas quando zhou mi ganhou simples feminino
 ###Tabelas: CREATE TABLE preliminary_round_ii (preliminary_round_ii_id AUTO_INCREMENT PRIMARY KEY, Team #1 VARCHAR, Agg. VARCHAR, Team #2 VARCHAR, 1st leg VARCHAR, 2nd leg VARCHAR) CREATE TABLE by_access_to_electricity (by_access_to_electricity_id AUTO_INCREMENT PRIMARY KEY, Region VARCHAR, Public network VARCHAR, Own/community generator VARCHAR, Solar panel VARCHAR, Other source VARCHAR, None VARCHAR) CREATE TABLE past_winners (past_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, Mens singles VARCHAR, Womens singles VARCHAR, Mens doubles VARCHAR, Womens doubles VARCHAR, Mixed doubles VARCHAR) CREATE TABLE historical_list_of_princeton_eating_clubs (historical_list_of_princeton_eating_clubs_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years of Operation VARCHAR, Location VARCHAR, Historical Photos VARCHAR, Year Clubhouse Constructed VARCHAR, Sign-in/Bicker VARCHAR, Year co-ed VARCHAR) CREATE TABLE season_5:_2005 (season_5:_2005_id AUTO_INCREMENT PRIMARY KEY, Series Ep. VARCHAR, Episode INT, Netflix VARCHAR, Segment A VARCHAR, Segment B VARCHAR, Segment C VARCHAR, Segment D VARCHAR)  
SELECT Mixed doubles FROM past_winners WHERE Womens singles = Zhou Mi