Show the nominees that have nominated musicals for both "Tony Award" and "Drama Desk Award".
CREATE TABLE musical (Nominee VARCHAR, Award VARCHAR)
SELECT Nominee FROM musical WHERE Award = "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award = "Drama Desk Award"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE musical (Nominee VARCHAR, Award VARCHAR) Question: Show the nominees that have nominated musicals for both "Tony Award" and "Drama Desk Award". [/INST] SELECT Nominee FROM musical WHERE Award = "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award = "Drama Desk Award" </s>