Database: musical
Question: Show different nominees and the number of musicals they have been nominated.
SQL:
SELECT Nominee ,  COUNT(*) FROM musical GROUP BY Nominee