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 liga tem um total menor que 16, um jogador de ken mckenna e uma Copa da Liga maior que 0?
 ###Tabelas: CREATE TABLE 2010_2011_table (2010_2011_table_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Played VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Tries for VARCHAR, Tries against VARCHAR, Try bonus VARCHAR, Losing bonus VARCHAR, Points VARCHAR) CREATE TABLE top_scorers_in_order_of_league_goals (top_scorers_in_order_of_league_goals_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Club VARCHAR, League INT, FA Cup INT, FA Trophy INT, League Cup INT, Total INT) CREATE TABLE statistics_leaders (statistics_leaders_id AUTO_INCREMENT PRIMARY KEY, Category VARCHAR, Player VARCHAR, Games played INT, Totals VARCHAR, Average VARCHAR) CREATE TABLE appearances_by_team (appearances_by_team_id AUTO_INCREMENT PRIMARY KEY, Appearances INT, Team VARCHAR, Wins INT, Losses INT, Winning percentage INT, Season(s) VARCHAR) CREATE TABLE most-visited_countries_by_international_tourist_arrivals (most-visited_countries_by_international_tourist_arrivals_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Country VARCHAR, UNWTO Region VARCHAR, International tourist arrivals (2012) VARCHAR, International tourist arrivals (2011) VARCHAR, Change (2011 to 2012) VARCHAR, Change (2010 to 2011) VARCHAR)  
SELECT MAX League FROM top_scorers_in_order_of_league_goals WHERE Total < 16 AND Player = ken mckenna AND League Cup > 0