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 é o número total de Super Cup, quando o Title Playoff for "0", quando o Total for maior que 9 e quando a League for menor que 11?
 ###Tabelas: CREATE TABLE 1947 (1947_id AUTO_INCREMENT PRIMARY KEY, Title VARCHAR, Series VARCHAR, Director VARCHAR, Production Number VARCHAR, Release date VARCHAR, reissue? VARCHAR) CREATE TABLE per_competition (per_competition_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, League INT, Title Playoff INT, Super Cup INT, Total INT) CREATE TABLE economies_of_member_states (economies_of_member_states_id AUTO_INCREMENT PRIMARY KEY, Member State sorted by GDP VARCHAR, GDP in s billion of USD (2012) VARCHAR, GDP % of EU (2012) VARCHAR, Annual change % of GDP (2012) VARCHAR, GDP per capita in PPP US$ (2012) INT, Public Debt % of GDP (2013 Q1) VARCHAR, Deficit (-)/ Surplus (+) % of GDP (2012) VARCHAR, Inflation % Annual (2012) VARCHAR, Unemp. % 2013 M7 VARCHAR) CREATE TABLE final_results (final_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Champion (average in final) VARCHAR, Legs VARCHAR, Runner-up (average in final) VARCHAR, Sponsor VARCHAR, Prize Fund VARCHAR, Champion VARCHAR, Runner-up VARCHAR, Venue VARCHAR) CREATE TABLE alumni (alumni_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Nationality VARCHAR, Position VARCHAR, Year of birth INT, Career VARCHAR, Appearances INT, Goals INT, Club VARCHAR)  
SELECT COUNT Super Cup FROM per_competition WHERE Title Playoff = 0 AND Total > 9 AND League < 11