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: Nomeie a autoridade quando o decil for 6 para a escola de Pongaroa.
 ###Tabelas: CREATE TABLE tararua_district (tararua_district_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, Gender VARCHAR, Area VARCHAR, Authority VARCHAR, Decile INT, Roll INT) CREATE TABLE defensive_player_of_the_year (defensive_player_of_the_year_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Player VARCHAR, Position VARCHAR, Nationality VARCHAR, Team VARCHAR) CREATE TABLE florida_league_alumni_-_top_5_round_picks__&__notables (florida_league_alumni_-_top_5_round_picks__&__notables_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, FCSL Team VARCHAR, Years Played VARCHAR, Year Drafted INT, Round VARCHAR, MLB Team VARCHAR) CREATE TABLE marriage_statistics (marriage_statistics_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Marriages between men INT, Marriages between women INT, Same-sex marriages INT, Total marriages INT, % same-sex marriages VARCHAR) CREATE TABLE government (government_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, 2012 Commission VARCHAR, 2010 Commission VARCHAR, 2007 Commission VARCHAR, 2002 Commission VARCHAR, 1999 Commission VARCHAR)  
SELECT Authority FROM tararua_district WHERE Decile = 6 AND Name = pongaroa school