human
Schema:
Person (name, age, city, gender, job)
PersonFriend (name, friend, year)
Please answer with SQL.
assistant
Sure, I understand.
human
Find the names of all person sorted in the descending order using age.
assistant
SELECT name FROM Person ORDER BY age DESC
human
Who is the person whose age is below 30?
assistant
SELECT name FROM Person WHERE age < 30
human
Who is the youngest male?
assistant
SELECT name FROM Person WHERE gender = 'male' AND age = (SELECT min(age) FROM person WHERE gender = 'male' )
human
Which person whose friends have the oldest average age?
assistant
SELECT T2.name , avg(T1.age) FROM Person AS T1 JOIN PersonFriend AS T2 ON T1.name = T2.friend GROUP BY T2.name ORDER BY avg(T1.age) DESC LIMIT 1
human
Who is the oldest person whose job is student?
assistant
SELECT name FROM Person WHERE job = 'student' AND age = (SELECT max(age) FROM person WHERE job = 'student' )
human
What is the name of the person who is the oldest?
assistant
SELECT name FROM Person WHERE age = ( SELECT MAX( age ) FROM person ) ;