CREATE TABLE albums (aid NUMBER, title CLOB, year NUMBER, label CLOB, type CLOB)
CREATE TABLE vocals (songid NUMBER, bandmate NUMBER, type CLOB)
CREATE TABLE tracklists (albumid NUMBER, position NUMBER, songid NUMBER)
CREATE TABLE songs (songid NUMBER, title CLOB)
CREATE TABLE instruments (songid NUMBER, bandmateid NUMBER, instrument CLOB)
CREATE TABLE performance (songid NUMBER, bandmate NUMBER, stageposition CLOB)
CREATE TABLE band (id NUMBER, firstname CLOB, lastname CLOB)

How many songs use drums as an instrument?
SELECT COUNT(*) FROM instruments WHERE instrument = "drums"
SELECT COUNT(*) FROM "instruments" WHERE "drums" = "instrument"