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: Em qual rodada o jogador Ty Lawson foi escolhido antes da 18ª?
 ###Tabelas: CREATE TABLE golden_globe_awards_–_fictional_presidents (golden_globe_awards_–_fictional_presidents_id AUTO_INCREMENT PRIMARY KEY, Year INT, Category VARCHAR, President VARCHAR, Nominee VARCHAR, Film or Television Series or Miniseries VARCHAR) CREATE TABLE team_players_drafted_into_the_nba (team_players_drafted_into_the_nba_id AUTO_INCREMENT PRIMARY KEY, Year INT, Round INT, Pick INT, Player VARCHAR, NBA Club VARCHAR) CREATE TABLE top_40_albums_of_2004 (top_40_albums_of_2004_id AUTO_INCREMENT PRIMARY KEY, Position INT, Album Title VARCHAR, Artist VARCHAR, Highest Position INT, Sales INT) CREATE TABLE endangered_wildlife_series (endangered_wildlife_series_id AUTO_INCREMENT PRIMARY KEY, Year INT, Theme VARCHAR, Face Values VARCHAR, Artist VARCHAR, Issue Price VARCHAR, Mintage INT, Finish VARCHAR) CREATE TABLE moves_played_compared_with_computer_choices (moves_played_compared_with_computer_choices_id AUTO_INCREMENT PRIMARY KEY, Position INT, best year VARCHAR, best 2-year period VARCHAR, best 3-year period VARCHAR, best 5-year period VARCHAR, best 10-year period VARCHAR, best 15-year period VARCHAR)  
SELECT AVG Round FROM team_players_drafted_into_the_nba WHERE Player = ty lawson AND Pick < 18