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 a pontuação final máxima no exercício de solo?
 ###Tabelas: CREATE TABLE current_teams (current_teams_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, City/Area VARCHAR, Arena VARCHAR, Founded INT, Joined INT, Head Coach VARCHAR, Captain VARCHAR) CREATE TABLE season-by-season (season-by-season_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Division VARCHAR, Finish VARCHAR, Wins VARCHAR, Losses VARCHAR, Pct. VARCHAR) CREATE TABLE regional_broadcast_television_networks (regional_broadcast_television_networks_id AUTO_INCREMENT PRIMARY KEY, Network VARCHAR, Flagship VARCHAR, Programming VARCHAR, Region VARCHAR, Origin VARCHAR, Owner VARCHAR) CREATE TABLE other_stakes_with_congregations_in_arkansas (other_stakes_with_congregations_in_arkansas_id AUTO_INCREMENT PRIMARY KEY, Stake VARCHAR, Organized VARCHAR, Number of Wards/ Branches in Arkansas INT, Stake President VARCHAR, Occupation VARCHAR) CREATE TABLE competitive_history (competitive_history_id AUTO_INCREMENT PRIMARY KEY, Year INT, Competition VARCHAR, Location VARCHAR, Apparatus VARCHAR, Rank-Final INT, Score-Final VARCHAR, Rank-Qualifying INT, Score-Qualifying VARCHAR)  
SELECT MAX Rank-Final FROM competitive_history WHERE Apparatus = Floor Exercise