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 é o grande finalista onde os vencedores são collingwood
 ###Tabelas: CREATE TABLE result_of_the_24th_election_to_the_new_zealand_house_of_representatives (result_of_the_24th_election_to_the_new_zealand_house_of_representatives_id AUTO_INCREMENT PRIMARY KEY, Party VARCHAR, Leader VARCHAR, Votes INT, Percentage VARCHAR, Seats INT) CREATE TABLE highest_goal-scorer (highest_goal-scorer_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Career VARCHAR, Goals INT, Caps INT, First Cap VARCHAR, Most Recent Cap VARCHAR) CREATE TABLE list_of_sovereign_nations_with_fewer_than_500000_people (list_of_sovereign_nations_with_fewer_than_500000_people_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Country/territory/entity VARCHAR, Population INT, % of world population VARCHAR, Region VARCHAR) CREATE TABLE night_series_winners_1977–1987 (night_series_winners_1977–1987_id AUTO_INCREMENT PRIMARY KEY, Year INT, Winners VARCHAR, Grand Finalist VARCHAR, Scores VARCHAR, Venue VARCHAR, Crowd INT, Margin INT, Season Result VARCHAR) CREATE TABLE season_by_season (season_by_season_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, League VARCHAR, Finish VARCHAR, Wins VARCHAR, Losses VARCHAR, Pct. VARCHAR)  
SELECT Grand Finalist FROM night_series_winners_1977–1987 WHERE Winners = Collingwood