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 foi o registro do Bronco quando jogaram contra o Detroit Lions no Estádio Mile High?
 ###Tabelas: CREATE TABLE rookie_list (rookie_list_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, AFL debut VARCHAR, Games VARCHAR, Goals VARCHAR, Kicks VARCHAR, Handballs VARCHAR, Disposals VARCHAR, Marks VARCHAR, Tackles VARCHAR) CREATE TABLE executive_commissioners (executive_commissioners_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Communications and Corporate Affairs VARCHAR, Human Resources & Operations VARCHAR, Local Affairs VARCHAR, Academic & University Affairs VARCHAR, External Affairs VARCHAR) CREATE TABLE schedule (schedule_id AUTO_INCREMENT PRIMARY KEY, Week VARCHAR, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, Game site VARCHAR, Record VARCHAR) CREATE TABLE record_vs._other_opponents_at_least_15_games_played (record_vs._other_opponents_at_least_15_games_played_id AUTO_INCREMENT PRIMARY KEY, Missouri vs. VARCHAR, Overall Record VARCHAR, at Columbia VARCHAR, at Opponents Venue VARCHAR, at Neutral Site VARCHAR, Last 5 Meetings VARCHAR, Last 10 Meetings VARCHAR, Current Streak VARCHAR) CREATE TABLE fixtures_results (fixtures_results_id AUTO_INCREMENT PRIMARY KEY, Competition VARCHAR, Round VARCHAR, Opponent VARCHAR, Result VARCHAR, Score VARCHAR, Home/Away VARCHAR, Venue VARCHAR, Attendance VARCHAR, Date VARCHAR)  
SELECT Record FROM schedule WHERE Game site = mile high stadium AND Opponent = detroit lions