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: Quantos roubos ocorreram na cidade onde a taxa de crimes violentos foi de 974,7?
 ###Tabelas: CREATE TABLE current_rolling_stock (current_rolling_stock_id AUTO_INCREMENT PRIMARY KEY, Class VARCHAR, Introduced VARCHAR, Number in class INT, Number in service INT, Power output (kW) INT) CREATE TABLE culinary_use (culinary_use_id AUTO_INCREMENT PRIMARY KEY, Total fat VARCHAR, Saturated fat VARCHAR, Monounsaturated fat VARCHAR, Polyunsaturated fat VARCHAR, Smoke point VARCHAR) CREATE TABLE international_matches_between_the_home_nations (international_matches_between_the_home_nations_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Stadium VARCHAR, Fixture VARCHAR, Status of Match VARCHAR, Score VARCHAR) CREATE TABLE during_regular_season (during_regular_season_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Outgoing manager VARCHAR, Manner of departure VARCHAR, Date of vacancy VARCHAR, Replaced by VARCHAR, Date of appointment VARCHAR, Position in table VARCHAR) CREATE TABLE 2012_calendar_year_ratios_of_crime_per_100000_population (2012_calendar_year_ratios_of_crime_per_100000_population_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, City VARCHAR, Population INT, Violent Crime VARCHAR, Murder and Non-Negligent Manslaughter VARCHAR, Forcible Rape VARCHAR, Robbery VARCHAR, Aggravated Assault VARCHAR, Property Crime VARCHAR, Burglary VARCHAR, Larceny-Theft VARCHAR, Motor Vehicle Theft VARCHAR)  
SELECT Burglary FROM 2012_calendar_year_ratios_of_crime_per_100000_population WHERE Violent Crime = 974.7