Hi, can you please tell me which country has a manager of age above 50?
select country from manager where age > 50
what about the countries with manager of age below 46?
select country from manager where age < 46
can you please tell me how many managers Scotland has?
select count ( * ) from manager where country = 'Scotland'
what about other countries?
select count ( * ), country from manager where country ! = 'Scotland' group by country
how many level 5 managers does United States have?
select count ( * ) from manager where country = 'United States' and level = 5
and can you please tell me their names?
select name from manager where country = 'United States' and level = 5