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 1ª perna da equipe 1 Lyon?
 ###Tabelas: CREATE TABLE first_knockout_round (first_knockout_round_id AUTO_INCREMENT PRIMARY KEY, Team 1 VARCHAR, Agg. VARCHAR, Team 2 VARCHAR, 1st leg VARCHAR, 2nd leg VARCHAR) CREATE TABLE seven_heavenly_virtues (seven_heavenly_virtues_id AUTO_INCREMENT PRIMARY KEY, Virtue VARCHAR, Latin VARCHAR, Gloss VARCHAR, (Vice) VARCHAR, (Latin) VARCHAR) CREATE TABLE table_of_broadcast_networks (table_of_broadcast_networks_id AUTO_INCREMENT PRIMARY KEY, Television Network VARCHAR, Founded VARCHAR, % of Venezuelan households reached VARCHAR, # of households viewable VARCHAR, Type of network VARCHAR, # of Full-Power Affiliates VARCHAR, # of Low-Power/Class-A Affiliates & Transmitters VARCHAR) CREATE TABLE personnel_and_sponsoring (personnel_and_sponsoring_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Head coach VARCHAR, Team captain VARCHAR, Kitmaker VARCHAR, Shirt sponsor VARCHAR) CREATE TABLE notable_players (notable_players_id AUTO_INCREMENT PRIMARY KEY, Nationality VARCHAR, Position VARCHAR, Leeds career VARCHAR, Appearances INT, Goals INT)  
SELECT 1st leg FROM first_knockout_round WHERE Team 1 = lyon