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 é a equipe da NHL no ranking de mercado de mídia número 7?
 ###Tabelas: CREATE TABLE overview_by_city (overview_by_city_id AUTO_INCREMENT PRIMARY KEY, Metropolitan Area VARCHAR, Media Market Ranking INT, Hosted 4 teams since INT, NFL Team(s) VARCHAR, MLB Team(s) VARCHAR, NBA Team(s) VARCHAR, NHL Team(s) VARCHAR) CREATE TABLE 1962_pro_draftees (1962_pro_draftees_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Draft VARCHAR, Round INT, Pick INT, Position VARCHAR, NFL Club VARCHAR) CREATE TABLE male_names (male_names_id AUTO_INCREMENT PRIMARY KEY, Region (year) VARCHAR, No. 1 VARCHAR, No. 2 VARCHAR, No. 3 VARCHAR, No. 4 VARCHAR, No. 5 VARCHAR, No. 6 VARCHAR, No. 7 VARCHAR, No. 8 VARCHAR, No. 9 VARCHAR, No. 10 VARCHAR) CREATE TABLE season-by-season (season-by-season_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Division VARCHAR, Finish VARCHAR, Wins VARCHAR, Losses VARCHAR, Pct. VARCHAR) CREATE TABLE season_by_season_results (season_by_season_results_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Manager VARCHAR, Record [a ] VARCHAR, Win % INT, Post-season record [e ] VARCHAR, Post-season win % VARCHAR, MLB affiliate VARCHAR)  
SELECT NHL Team(s) FROM overview_by_city WHERE Media Market Ranking = 7