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 the name of actors in ascending alphabetical order.
assistant
SELECT Name FROM actor ORDER BY Name ASC
human
List the name of actors whose age is not 20.
assistant
SELECT Name FROM actor WHERE Age != 20
human
How many actors are there?
assistant
SELECT count(*) FROM actor
human
What are the characters of actors in descending order of age?
assistant
SELECT Character FROM actor ORDER BY age DESC
human
What are the characters and duration of actors?
assistant
SELECT Character , Duration FROM actor
human
What is the duration of the oldest actor?
assistant
SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1 ;