how many times is the building type residential and the locale yashodham?
CREATE TABLE table_name_22 (sr_no VARCHAR, building_type VARCHAR, locale VARCHAR)
SELECT COUNT(sr_no) FROM table_name_22 WHERE building_type = "residential" AND locale = "yashodham"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (sr_no VARCHAR, building_type VARCHAR, locale VARCHAR) Question: how many times is the building type residential and the locale yashodham? [/INST] SELECT COUNT(sr_no) FROM table_name_22 WHERE building_type = "residential" AND locale = "yashodham" </s>