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 Total tem um medalhista de bronze olímpico?
 ###Tabelas: CREATE TABLE casualties (casualties_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Security Forces VARCHAR, Insurgents VARCHAR, Civilians VARCHAR, Total: VARCHAR) CREATE TABLE week_5:_august_6_and_7_2008 (week_5:_august_6_and_7_2008_id AUTO_INCREMENT PRIMARY KEY, Main contestant VARCHAR, Co-contestant (Yaar vs. Pyaar) VARCHAR, Date performed VARCHAR, Scores by each individual judge VARCHAR, Total score/week VARCHAR, Position VARCHAR, Status VARCHAR) CREATE TABLE qualification (qualification_id AUTO_INCREMENT PRIMARY KEY, Shooter VARCHAR, Event VARCHAR, Rank points VARCHAR, Score points VARCHAR, Total VARCHAR) CREATE TABLE comparison_of_cad_cam_cae_file_viewers (comparison_of_cad_cam_cae_file_viewers_id AUTO_INCREMENT PRIMARY KEY, Latest stable release VARCHAR, Developer VARCHAR, 3D support? VARCHAR, Runs on POSIX style systems ? VARCHAR, Runs on Windows? VARCHAR, User Interface Language(s) VARCHAR) CREATE TABLE full_results (full_results_id AUTO_INCREMENT PRIMARY KEY, Finished VARCHAR, Post INT, Horse VARCHAR, Jockey VARCHAR, Trainer VARCHAR, Odds INT)  
SELECT Total FROM qualification WHERE Rank points = olympic bronze medalist