State the email id of custormer id 1?
select email from customer where customerid = '1'
How many employees are from Calgary city?
select count ( * ) from employee where city = 'Calgary'
Please show the employee first names and ids of employees who serve at least 10 customers?
select t1.firstname, t1.supportrepid from customer as t1 join employee as t2 on t1.supportrepid = t2.employeeid group by t1.supportrepid having count ( * ) > = 10
State the title of employee id 2?
select title from employee where employeeid = 2