what is the total number of record where streak is l2 and leading scorer is roy : 23
CREATE TABLE table_11964047_5 (record VARCHAR, streak VARCHAR, leading_scorer VARCHAR)
SELECT COUNT(record) FROM table_11964047_5 WHERE streak = "L2" AND leading_scorer = "Roy : 23"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11964047_5 (record VARCHAR, streak VARCHAR, leading_scorer VARCHAR) Question: what is the total number of record where streak is l2 and leading scorer is roy : 23 [/INST] SELECT COUNT(record) FROM table_11964047_5 WHERE streak = "L2" AND leading_scorer = "Roy : 23" </s>