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
What are the characters and duration of actors?
assistant
SELECT Character , Duration FROM actor
human
Show names of actors in descending order of the year their musical is awarded.
assistant
SELECT T1.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID ORDER BY T2.Year DESC
human
What is the duration of the oldest actor?
assistant
SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1
human
List the name of actors whose age is not 20.
assistant
SELECT Name FROM actor WHERE Age != 20
human
List the name of actors in ascending alphabetical order.
assistant
SELECT Name FROM actor ORDER BY Name ASC
human
Return the characters for actors, ordered by age descending.
assistant
SELECT Character FROM actor ORDER BY age DESC ;