SELECT count(*) FROM instruments WHERE instrument  =  "drums"
How many songs use drums as an instrument?
SELECT count ( * ) FROM instruments WHERE instrument = `` drums ''
select count ( * ) from instruments where instrument = value
How many songs use drums as an instrument ?