human
Schema:
railway (Railway_ID, Railway, Builder, Built, Wheels, Location, ObjectNumber)
train (Train_ID, Train_Num, Name, From, Arrival, Railway_ID)
manager (Manager_ID, Name, Country, Working_year_starts, Age, Level)
railway_manage (Railway_ID, Manager_ID, From_Year)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the countries that have managers of age above 50 or below 46.
assistant
SELECT Country FROM manager WHERE Age > 50 OR Age < 46
human
Show the countries that have both managers of age above 50 and managers of age below 46.
assistant
SELECT Country FROM manager WHERE Age > 50 INTERSECT SELECT Country FROM manager WHERE Age < 46
human
Show the working years of managers in descending order of their level.
assistant
SELECT Working_year_starts FROM manager ORDER BY LEVEL DESC
human
What is the average age for all managers?
assistant
SELECT avg(Age) FROM manager
human
What are the names of managers in ascending order of level?
assistant
SELECT Name FROM manager ORDER BY LEVEL ASC
human
What is the name of the oldest manager?
assistant
SELECT Name FROM manager ORDER BY Age DESC LIMIT 1 ;