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 torneio tem um vice-campeão de Gary McCord?
 ###Tabelas: CREATE TABLE faculty_and_staff (faculty_and_staff_id AUTO_INCREMENT PRIMARY KEY, Data VARCHAR, Headcount INT, Percent of total VARCHAR, Less than $25,000 VARCHAR, $25,000 to $40,000 VARCHAR, $40,000 to $50,000 VARCHAR, $50,000 to $60,000 VARCHAR, $60,000 to $70,000 VARCHAR, $70,000 to $80,000 VARCHAR, More than $80,000 VARCHAR, Mean VARCHAR) CREATE TABLE principle (principle_id AUTO_INCREMENT PRIMARY KEY, Group INT, Half-Life (s) INT, Decay Constant (s −1 ) INT, Yield, Neutrons per Fission INT, Fraction INT) CREATE TABLE women's (women's_id AUTO_INCREMENT PRIMARY KEY, Skip VARCHAR, Third VARCHAR, Second VARCHAR, Lead VARCHAR, City VARCHAR) CREATE TABLE 1947 (1947_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Series VARCHAR, Director VARCHAR, Production Number VARCHAR, Release date VARCHAR, reissue? VARCHAR) CREATE TABLE champions_tour_wins_8 (champions_tour_wins_8_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Winning score VARCHAR, Margin of victory VARCHAR, Runner(s)-up VARCHAR)  
SELECT Tournament FROM champions_tour_wins_8 WHERE Runner(s)-up = gary mccord