How many employees are IT Staff?
select count ( * ) from employees where title = 'IT Staff'
How many are in Calgary?
select count ( * ) from employees where title = 'IT Staff' and city = 'Calgary'
how about in Edmonton?
select count ( * ) from employees where title = 'IT Staff' and city = 'Edmonton'
yes, the two employees with the title of IT Staff.
select distinct city from employees where title = 'IT Staff'