SELECT COUNT(*) FROM orchestra WHERE Major_Record_Format  =  "CD" OR Major_Record_Format  =  "DVD"
Count the number of orchestras that have CD or DVD as their record format.
SELECT COUNT ( * ) FROM orchestra WHERE Major_Record_Format = `` CD '' OR Major_Record_Format = `` DVD ''
select count ( * ) from orchestra where major_record_format = value or major_record_format = value
Count the number of orchestras that have CD or DVD as their record format .