what is the total number of constancy where purity is falling
CREATE TABLE table_11609814_1 (constancy VARCHAR, purity VARCHAR)
SELECT COUNT(constancy) FROM table_11609814_1 WHERE purity = "falling"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11609814_1 (constancy VARCHAR, purity VARCHAR) Question: what is the total number of constancy where purity is falling [/INST] SELECT COUNT(constancy) FROM table_11609814_1 WHERE purity = "falling" </s>