CREATE TABLE musical (musical_id DECIMAL, name TEXT, year DECIMAL, award TEXT, category TEXT, nominee TEXT, result TEXT)
CREATE TABLE actor (actor_id DECIMAL, name TEXT, musical_id DECIMAL, character TEXT, duration TEXT, age DECIMAL)

Show different nominees and the number of musicals they have been nominated.
SELECT nominee, COUNT(*) FROM musical GROUP BY nominee
SELECT "nominee", COUNT(*) FROM "musical" GROUP BY "nominee"