Hello,

I have two questions i need to generate queries for but I am not sure how I would go about this.

I have the following tables:
dept,
emp,
jobs,
job_history,
location,
managers,

How many departments are housed in each location and how many employees work there?

What is the total salary expenditure for employees per department in 2011 compared to 2010?

I am clueless right now. Thank you for any help