HR wants to send the completed budget reports to the various department managers managers are

employees To do so they need a current listing of the department managers to contact. For this query, the

HR department needs the department name, manager first name, manager last name, job title, the managers

email address and the stateprovince and country. The results must be sorted by department name and include

the elements in the order listed.

Business Question :

To help with anticipating the amount needed per employee for the costofliving stipends for those living in

other countries, the HR department needs to know how many employees are living in each county. The

employee count should only include active employees. The query results need to include the name of the

unabbreviated country and the number of employees in that country. The column heading for the number of

employees should be Number of Employees