Name the total number of roll for state authority and stanley avenue school with decile more than 5
CREATE TABLE table_name_31 (roll VARCHAR, decile VARCHAR, authority VARCHAR, name VARCHAR)
SELECT COUNT(roll) FROM table_name_31 WHERE authority = "state" AND name = "stanley avenue school" AND decile > 5
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_31 (roll VARCHAR, decile VARCHAR, authority VARCHAR, name VARCHAR) Question: Name the total number of roll for state authority and stanley avenue school with decile more than 5 [/INST] SELECT COUNT(roll) FROM table_name_31 WHERE authority = "state" AND name = "stanley avenue school" AND decile > 5 </s>