Database: musical
Question: How many musicals has each nominee been nominated for?
SQL:
SELECT Nominee ,  COUNT(*) FROM musical GROUP BY Nominee