Table: us_city_sports_teams
Columns: metropolitan_area
media_market_ranking
hosted_4_teams_since
nfl_team_s
mlb_team_s
nba_team_s
nhl_team_s

Question: How many NHL teams are there in the Phoenix, Arizona area?
SQL: SELECT COUNT("nhl_team_s") FROM us_city_sports_teams WHERE "metropolitan_area" = 'Phoenix, Arizona'

Question: What is the media market ranking for the Blackhawks?
SQL: SELECT COUNT("media_market_ranking") FROM us_city_sports_teams WHERE "nhl_team_s" = 'Blackhawks'

Question: What is the the name of the NHL team that is in the same market as the NBA team, Nuggets?
SQL: SELECT "nhl_team_s" FROM us_city_sports_teams WHERE "nba_team_s" = 'Nuggets'

Question: What is the NHL team in the media market ranking number 7?
SQL: SELECT "nhl_team_s" FROM us_city_sports_teams WHERE "media_market_ranking" = 7