text: CREATE TABLE musical (RESULT VARCHAR) -- List the most common result of the musicals. SELECT RESULT FROM musical GROUP BY RESULT ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE musical (Nominee VARCHAR) -- List the nominees that have been nominated more than two musicals. SELECT Nominee FROM musical GROUP BY Nominee HAVING COUNT(*) > 2 CREATE TABLE actor (Name VARCHAR, Musical_ID VARCHAR); CREATE TABLE musical (Name VARCHAR, Musical_ID VARCHAR) -- List the name of musicals that do not have actors. SELECT Name FROM musical WHERE NOT Musical_ID IN (SELECT Musical_ID FROM actor) CREATE TABLE musical (Nominee VARCHAR, Award VARCHAR) -- Show the nominees that have nominated musicals for both "Tony Award" and "Drama Desk Award". SELECT Nominee FROM musical WHERE Award = "Tony Award" INTERSECT SELECT Nominee FROM musical WHERE Award = "Drama Desk Award" CREATE TABLE musical (Nominee VARCHAR, Award VARCHAR) -- Show the musical nominee with award "Bob Fosse" or "Cleavant Derricks". SELECT Nominee FROM musical WHERE Award = "Tony Award" OR Award = "Cleavant Derricks" CREATE TABLE user_profiles (email VARCHAR, name VARCHAR) -- Find the emails of the user named "Mary". SELECT email FROM user_profiles WHERE name = 'Mary' CREATE TABLE user_profiles (partitionid VARCHAR, name VARCHAR) -- What is the partition id of the user named "Iron Man". SELECT partitionid FROM user_profiles WHERE name = 'Iron Man' CREATE TABLE user_profiles (Id VARCHAR) -- How many users are there? SELECT COUNT(*) FROM user_profiles