Find the number of orchestras whose record format is "CD" or "DVD".
CREATE TABLE orchestra (Major_Record_Format VARCHAR)
SELECT COUNT(*) FROM orchestra WHERE Major_Record_Format = "CD" OR Major_Record_Format = "DVD"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE orchestra (Major_Record_Format VARCHAR) Question: Find the number of orchestras whose record format is "CD" or "DVD". [/INST] SELECT COUNT(*) FROM orchestra WHERE Major_Record_Format = "CD" OR Major_Record_Format = "DVD" </s>