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: Qual é a maior presença em um jogo jogado pelo St. Johnstone?
 ###Tabelas: CREATE TABLE attendances (attendances_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Stadium VARCHAR, Capacity INT, Highest INT, Lowest INT, Average INT) CREATE TABLE universities (universities_id AUTO_INCREMENT PRIMARY KEY, Members VARCHAR, Country VARCHAR, Year Established INT, World Rank by THE-WUR , 2013 VARCHAR, World Rank by ARWU , 2013 VARCHAR, World Rank by QS , 2013 VARCHAR) CREATE TABLE table_of_federal_taxation_and_spending_by_state (table_of_federal_taxation_and_spending_by_state_id AUTO_INCREMENT PRIMARY KEY, Rank INT, State VARCHAR, Revenue (millions) VARCHAR, Population INT, Revenue per capita VARCHAR, Spending (millions) VARCHAR, Spending per capita VARCHAR, Net contribution per capita VARCHAR, Presidential majority 2000/2004 VARCHAR, Presidential majority 2008 VARCHAR, Presidential majority 2012 VARCHAR, Obamacare: Fed/ State/ Partnership VARCHAR) CREATE TABLE list_of_boxing_quintuple_or_five_division_champions_—_major_titles (list_of_boxing_quintuple_or_five_division_champions_—_major_titles_id AUTO_INCREMENT PRIMARY KEY, Number INT, Name VARCHAR, Titles VARCHAR, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, Defenses INT) CREATE TABLE list_of_dmfas_programme_managers_and_chiefs (list_of_dmfas_programme_managers_and_chiefs_id AUTO_INCREMENT PRIMARY KEY, Number INT, Name VARCHAR, Dates in office VARCHAR, Country of origin VARCHAR, Remarks VARCHAR)  
SELECT MAX Highest FROM attendances WHERE Team = St. Johnstone