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
Please 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
Please show me the names of all those managers
assistant
SELECT name FROM manager;
human
Please show me the age of the youngest and oldest managers
assistant
SELECT MIN( age ) , MAX( age ) FROM manager ;