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 time tem posição de nc para a temporada de 2010?
 ###Tabelas: CREATE TABLE member_schools (member_schools_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Nickname VARCHAR, Location VARCHAR, Founded INT, Joined ACC INT, School Type VARCHAR, ACC Football Titles INT) CREATE TABLE ethnic_groups_and_demographics (ethnic_groups_and_demographics_id AUTO_INCREMENT PRIMARY KEY, Raion (district) or City VARCHAR, Total VARCHAR, Ukrainians VARCHAR, Moldovans VARCHAR, Bessarabian Bulgarians VARCHAR, Russians VARCHAR, Gagauzians VARCHAR, Other ethnic groups² VARCHAR) CREATE TABLE sports_teams (sports_teams_id AUTO_INCREMENT PRIMARY KEY, Sport VARCHAR, League VARCHAR, Club VARCHAR, Founded INT, Venue VARCHAR, League championships INT, Championship years VARCHAR) CREATE TABLE islands_over___square_miles__ km_ (islands_over___square_miles__ km__id AUTO_INCREMENT PRIMARY KEY, Rank INT, Islands Name VARCHAR, Area (sqmi) INT, Area (km 2 ) INT, Location VARCHAR, Population (2000) VARCHAR) CREATE TABLE career_summary (career_summary_id AUTO_INCREMENT PRIMARY KEY, Season INT, Series VARCHAR, Team VARCHAR, Races INT, Wins INT, Poles INT, F/Laps INT, Podiums INT, Points VARCHAR, Position VARCHAR)  
SELECT Team FROM career_summary WHERE Position = NC AND Season = 2010