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: Quantas das escolas listadas estão em Ames, IA?
 ###Tabelas: CREATE TABLE maungakiekie–tamaki_local_board (maungakiekie–tamaki_local_board_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, Area VARCHAR, Authority VARCHAR, Decile VARCHAR, Roll INT) CREATE TABLE the_full_chart (the_full_chart_id AUTO_INCREMENT PRIMARY KEY, Finish Position VARCHAR, Lengths Behind VARCHAR, Post Position INT, Horse name VARCHAR, Trainer VARCHAR, Jockey VARCHAR, Owner VARCHAR, Post Time Odds VARCHAR) CREATE TABLE current_members (current_members_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Founded INT, Affiliation VARCHAR, Enrollment INT, Team Nickname VARCHAR, Primary conference VARCHAR) CREATE TABLE sun-like_stars_with_hot_dust (sun-like_stars_with_hot_dust_id AUTO_INCREMENT PRIMARY KEY, Star VARCHAR, Stellar classification VARCHAR, Distance from Earth ( ly ) VARCHAR, Constellation VARCHAR, Dust (or Debris; Temperature (K) VARCHAR, System VARCHAR, Dust (or Debris) Location (AU) VARCHAR, Cool Dust > 10 AU VARCHAR, Stellar Age (Myr) VARCHAR) CREATE TABLE women's_singles (women's_singles_id AUTO_INCREMENT PRIMARY KEY, Sd INT, Rk INT, Player VARCHAR, Points INT, Points defending INT, Points won INT, New points INT, Status VARCHAR)  
SELECT COUNT Primary conference FROM current_members WHERE Location = Ames, IA