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