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 escolas estão localizadas em South Brisbane?
 ###Tabelas: CREATE TABLE participating_schools (participating_schools_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Enrolment INT, Founded INT, Denomination VARCHAR, Day/Boarding VARCHAR, School Colours VARCHAR, Abbreviation VARCHAR, In competition since INT) CREATE TABLE tv_ratings (tv_ratings_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Broadcast date VARCHAR, BBC One total viewing VARCHAR, BBC One Rank VARCHAR, BBC Two total viewing VARCHAR, BBC Two Rank VARCHAR) CREATE TABLE doubles_10_6–4 (doubles_10_6–4_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in Final VARCHAR, Score in Final VARCHAR) CREATE TABLE atp_doubles_finals:_13_6–7 (atp_doubles_finals:_13_6–7_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partnering VARCHAR, Opponents in the final VARCHAR, Score VARCHAR) CREATE TABLE other_wins_11 (other_wins_11_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Winning score VARCHAR, To par VARCHAR, Margin of victory VARCHAR, Runner(s)-up VARCHAR)  
SELECT COUNT School FROM participating_schools WHERE Location = South Brisbane