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: Quantas figuras são fornecidas para pubs 2011 em Chennai?
 ###Tabelas: CREATE TABLE passengers_carried_in_2010 (passengers_carried_in_2010_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Airline VARCHAR, Country VARCHAR, Passengers Carried INT, Remarks VARCHAR, Alliance VARCHAR) CREATE TABLE series_5 (series_5_id AUTO_INCREMENT PRIMARY KEY, Episode VARCHAR, First aired VARCHAR, Entrepreneur(s) VARCHAR, Company or product name VARCHAR, Money requested (£) INT, Investing Dragon(s) VARCHAR) CREATE TABLE rankings (rankings_id AUTO_INCREMENT PRIMARY KEY, SCHOOL VARCHAR, LOCATION VARCHAR, PUBS. 2010 INT, TOTALS 06-10 INT, RANK 06-10 INT, PUBS 2011 INT, TOTALS 07-11 INT, RANK 07-11 INT, WORLD RANKING VARCHAR) CREATE TABLE erm_ii_members (erm_ii_members_id AUTO_INCREMENT PRIMARY KEY, Currency VARCHAR, Code VARCHAR, Entry ERM II VARCHAR, Central rate VARCHAR, Official target date VARCHAR) CREATE TABLE character_appearances (character_appearances_id AUTO_INCREMENT PRIMARY KEY, Character VARCHAR, Played by VARCHAR, Season 1 INT, Season 2 INT, Season 3 INT, Season 4 INT, First Appearance VARCHAR)  
SELECT COUNT PUBS 2011 FROM rankings WHERE LOCATION = Chennai