user: Question: How many schools are located in South Brisbane?
Columns: ['School', 'Location', 'Enrolment', 'Founded', 'Denomination', 'Day/Boarding', 'School Colours', 'Abbreviation', 'In competition since']
Types: ['text', 'text', 'real', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: ["All Hallows' School", 'Brisbane', 1300.0, 1861.0, 'Catholic', 'Day', 'Light Blue & White', 'AHS', 1990.0]
SQL:

assistant: SELECT COUNT("School") FROM "Table" WHERE "Location" = 'South Brisbane';