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 GLF Premiership os Magpies tiveram?
 ###Tabelas: CREATE TABLE 1996 (1996_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Opponent VARCHAR, Site VARCHAR, Result VARCHAR, Attendance VARCHAR) CREATE TABLE former (former_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Nickname VARCHAR, Location VARCHAR, GFL Premierships VARCHAR, Years in GFL VARCHAR) CREATE TABLE racial_composition (racial_composition_id AUTO_INCREMENT PRIMARY KEY, Municipality (2010) VARCHAR, White (both Hispanic and Non-Hispanic) INT, Black (Both Hispanic and Non-Hispanic) INT, Amerindian (Both Hispanic and Non-Hispanic) INT, n Asia (Both Hispanic and Non-Hispanic) INT, Multiracial (Both Hispanic and Non-Hispanic) INT, Hispanic (Of any Race) INT) CREATE TABLE -_girone_b (-_girone_b_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, City VARCHAR, Stadium VARCHAR, Capacity INT, 2011–12 season VARCHAR) CREATE TABLE touchdowns (touchdowns_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Rec. INT, Yards INT, Avg. INT, TD's INT, Long INT)  
SELECT GFL Premierships FROM former WHERE Nickname = magpies