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 posição foi retirada de Louisiana-Lafayette?
 ###Tabelas: CREATE TABLE analytical_table (analytical_table_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Votes INT, Votes since 1856 INT, Democratic votes INT, D votes since 1856 INT, % of D votes VARCHAR, D % since 1856 VARCHAR, Republican votes INT, % of R votes VARCHAR, R % since 1856 VARCHAR, Other votes INT, O votes since 1856 INT, % of O votes VARCHAR, O % since 1856 VARCHAR) CREATE TABLE round_one (round_one_id AUTO_INCREMENT PRIMARY KEY, Pick # INT, CFL Team VARCHAR, Player VARCHAR, Position VARCHAR, College VARCHAR) CREATE TABLE diemaco_colt_canada_models (diemaco_colt_canada_models_id AUTO_INCREMENT PRIMARY KEY, Colt model no. VARCHAR, Diemaco model VARCHAR, Stock VARCHAR, Fire control VARCHAR, Rear sight VARCHAR, Forward assist VARCHAR, Barrel length VARCHAR, Barrel profile VARCHAR, Barrel twist VARCHAR, Hand guards VARCHAR, Bayonet Lug VARCHAR, Muzzle device VARCHAR) CREATE TABLE prime_ministers (prime_ministers_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Entered office VARCHAR, Left office VARCHAR, Political party VARCHAR, Monarchs served VARCHAR, Birth Place VARCHAR) CREATE TABLE singles:_14_6–8 (singles:_14_6–8_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Opponent VARCHAR, Score VARCHAR)  
SELECT Position FROM round_one WHERE College = Louisiana-Lafayette