How many burglaries occurred in the city where the violent crime rate was 974.7?
CREATE TABLE table_1818254_1 (burglary VARCHAR, violent_crime VARCHAR)
SELECT burglary FROM table_1818254_1 WHERE violent_crime = "974.7"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_1818254_1 (burglary VARCHAR, violent_crime VARCHAR) Question: How many burglaries occurred in the city where the violent crime rate was 974.7? [/INST] SELECT burglary FROM table_1818254_1 WHERE violent_crime = "974.7" </s>