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 rodada teve o oponente Lyon?
 ###Tabelas: CREATE TABLE goalkeeping_leaders (goalkeeping_leaders_id AUTO_INCREMENT PRIMARY KEY, No. INT, Player VARCHAR, Club VARCHAR, Games Played INT, Minutes INT, Goals Against INT, GA Average VARCHAR, Wins INT, Loses INT) CREATE TABLE group_b (group_b_id AUTO_INCREMENT PRIMARY KEY, Home team VARCHAR, Home team score VARCHAR, Away team VARCHAR, Away team score VARCHAR, Ground VARCHAR, Crowd INT, Date VARCHAR) CREATE TABLE european_competition_history (european_competition_history_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Competition VARCHAR, Round VARCHAR, Club VARCHAR, Home VARCHAR, Away VARCHAR, Aggregate VARCHAR) CREATE TABLE club_brugge (club_brugge_id AUTO_INCREMENT PRIMARY KEY, Round VARCHAR, Opposition VARCHAR, First leg VARCHAR, Second leg VARCHAR, Aggregate score VARCHAR) CREATE TABLE 2000_nfl_draft (2000_nfl_draft_id AUTO_INCREMENT PRIMARY KEY, Round INT, Overall INT, Player VARCHAR, Position VARCHAR, College VARCHAR)  
SELECT Round FROM club_brugge WHERE Opposition = lyon