Show different nominees and the number of musicals they have been nominated.
CREATE TABLE musical (Nominee VARCHAR)
SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE musical (Nominee VARCHAR) Question: Show different nominees and the number of musicals they have been nominated. [/INST] SELECT Nominee, COUNT(*) FROM musical GROUP BY Nominee </s>