human
Schema:
musical (Musical_ID, Name, Year, Award, Category, Nominee, Result)
actor (Actor_ID, Name, Musical_ID, Character, Duration, age)
Please answer with SQL.
assistant
Sure, I understand.
human
Show all the nominees.
assistant
SELECT Nominee FROM musical;
human
Count how many musicals for each one.
assistant
SELECT Nominee , COUNT( * ) FROM musical GROUP BY Nominee ;