Show all the different cities that employees are from.
select distinct city from employees
How many are from each one!
select count(*), city from employees group by city
How many are of the title Sales Support Agent?
select count(*), city from employees where title = 'Sales support Agent' group by city
How about IT Staff?
select count(*), city from employees where title = 'IT Staff' group by city