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 estação tem flora como vice-campeã, tvmk na 3ª posição e narva trans como o principal artilheiro(s)?
 ###Tabelas: CREATE TABLE profiles (profiles_id AUTO_INCREMENT PRIMARY KEY, Profile VARCHAR, Bandwidth ( MHz ) VARCHAR, Number of carriers INT, Carrier bandwidth (kHz) VARCHAR, Power ( dBm ) VARCHAR, Max. downstream throughput ( Mbit/s ) INT) CREATE TABLE guest_performances (guest_performances_id AUTO_INCREMENT PRIMARY KEY, Week VARCHAR, Performer(s) VARCHAR, Hot 100 Reaction VARCHAR, Hot Digital Songs Reaction VARCHAR, Notes VARCHAR) CREATE TABLE final_results (final_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Champion (average in final) VARCHAR, Legs VARCHAR, Runner-up (average in final) VARCHAR, Sponsor VARCHAR, Prize Fund VARCHAR, Champion VARCHAR, Runner-up VARCHAR, Venue VARCHAR) CREATE TABLE medals_summary (medals_summary_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT) CREATE TABLE champions_and_top_goalscorers (champions_and_top_goalscorers_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Champion VARCHAR, Runner-Up VARCHAR, 3rd Position VARCHAR, Top Goalscorer(s) VARCHAR, Team(s) INT)  
SELECT Season FROM champions_and_top_goalscorers WHERE Runner-Up = flora AND 3rd Position = tvmk AND Top Goalscorer(s) = narva trans