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: Quantos mascotes existem para College Station, Texas?
 ###Tabelas: CREATE TABLE world_energy_intensity_progression_by_year. (world_energy_intensity_progression_by_year._id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Unit p koe/$05 VARCHAR, 2006 INT, 2007 INT, 2008 INT, 2009 INT) CREATE TABLE division_i (division_i_id AUTO_INCREMENT PRIMARY KEY, Institution VARCHAR, Location VARCHAR, Founded INT, Affiliation VARCHAR, Enrollment INT, Team Nickname VARCHAR, Primary conference VARCHAR) CREATE TABLE raiding_career (raiding_career_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Ship VARCHAR, Type VARCHAR, Nationality VARCHAR, Tonnage GRT INT) CREATE TABLE switzerland (switzerland_id AUTO_INCREMENT PRIMARY KEY, Internet Plan VARCHAR, Downstream VARCHAR, Upstream VARCHAR, Bandwidth Included VARCHAR, Price VARCHAR) CREATE TABLE total_playoff_berths_while_in_the_afl_afc_east (total_playoff_berths_while_in_the_afl_afc_east_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Division Titles INT, Playoff Berths INT, AFL Titles INT, AFC Championships INT, Super Bowl Championships INT)  
SELECT COUNT Team Nickname FROM division_i WHERE Location = College Station, Texas