Database: orchestra
Question: Find the number of orchestras whose record format is "CD" or "DVD".
SQL:
SELECT COUNT(*) FROM orchestra WHERE Major_Record_Format  =  "CD" OR Major_Record_Format  =  "DVD"