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 é o time visitante do jogo com uma presença de 117 pessoas?
 ###Tabelas: CREATE TABLE list_of_the_most_populous_us_counties_sorted_according_to_the_mid-2011_official_estimate_by_the_uscb (list_of_the_most_populous_us_counties_sorted_according_to_the_mid-2011_official_estimate_by_the_uscb_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, County VARCHAR, State VARCHAR, Land area (km²) VARCHAR, Land area (mi²) VARCHAR, April 1, 2010 census VARCHAR, April 1, 2010 density (/km²) VARCHAR, April 1, 2010 density (/mi²) VARCHAR, July 1, 2010 official estimate VARCHAR, July 1, 2010 density (/km²) VARCHAR, July 1, 2010 density (/mi²) VARCHAR, July 1, 2011 official estimate VARCHAR, July 1, 2011 density (/km²) VARCHAR, July 1, 2011 density (/mi²) VARCHAR, Mid-2010 to mid-2011 change (Absolute) VARCHAR, Mid-2010 to mid-2011 change (%) VARCHAR, County seat or courthouse VARCHAR) CREATE TABLE connecticut (connecticut_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, First elected INT, Results VARCHAR) CREATE TABLE consolation_night_series_lake_oval_winners_1956–1971 (consolation_night_series_lake_oval_winners_1956–1971_id AUTO_INCREMENT PRIMARY KEY, Year INT, Winners VARCHAR, Grand Finalist VARCHAR, Scores VARCHAR, Venue VARCHAR, Crowd INT, Margin INT, Season Result VARCHAR) CREATE TABLE new_york_counties_ranked_by_per_capita_income (new_york_counties_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Per capita income VARCHAR, Median household income VARCHAR, Median family income VARCHAR, Population INT, Number of households INT) CREATE TABLE ties (ties_id AUTO_INCREMENT PRIMARY KEY, Tie no INT, Home team VARCHAR, Score VARCHAR, Away team VARCHAR, Attendance INT)  
SELECT Away team FROM ties WHERE Attendance = 117