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 all the level of managers.
assistant
SELECT LEVEL FROM manager;
human
What is the average level?
assistant
SELECT AVG ( LEVEL ) FROM manager;
human
What is that of the managers that come from 'United States'?
assistant
SELECT AVG ( LEVEL ) FROM manager WHERE Country != 'United States';
human
What is the maximum level of managers that do not come from 'Australia'?
assistant
SELECT MAX( LEVEL ) FROM manager WHERE Country != "Australia" ;