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
List all the information about musicals.
assistant
SELECT * FROM musical;
human
Show all the names of musicals which have actors.
assistant
SELECT Name FROM musical WHERE Musical_ID IN ( SELECT Musical_ID FROM actor ) ;