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: Quem foi o campeão em 2005, onde o semi-finalista era o #1 no oeste da Carolina?
 ###Tabelas: CREATE TABLE communities (communities_id AUTO_INCREMENT PRIMARY KEY, Official Name VARCHAR, Status VARCHAR, Area km 2 INT, Population INT, Census Ranking VARCHAR) CREATE TABLE sources_of_income (sources_of_income_id AUTO_INCREMENT PRIMARY KEY, Region VARCHAR, Employment ( salaries & wages) VARCHAR, Self employed VARCHAR, Investment income VARCHAR, Working tax credit VARCHAR, State pensions VARCHAR, Occupational pensions VARCHAR, Disability benefits VARCHAR, Other social security benefits VARCHAR, Other income sources VARCHAR) CREATE TABLE division_ii (division_ii_id AUTO_INCREMENT PRIMARY KEY, Year INT, Champion VARCHAR, Score VARCHAR, Runner-Up VARCHAR, Location VARCHAR, Semi-Finalist #1 VARCHAR, Semi-Finalist #2 VARCHAR) CREATE TABLE navies_and_ships_involved (navies_and_ships_involved_id AUTO_INCREMENT PRIMARY KEY, Warship VARCHAR, tons ( L.ton ) VARCHAR, Horse- power INT, Speed ( Knots ) INT, Main Artillery VARCHAR, Built Year INT) CREATE TABLE past_members (past_members_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Nickname VARCHAR, Location VARCHAR, Founded INT, Type VARCHAR, Enrollment VARCHAR, Current Conference VARCHAR)  
SELECT Champion FROM division_ii WHERE Year = 2005 AND Semi-Finalist #1 = western carolina