-
Query Help needed
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 :)
-
Some more info is needed, what do the tables look like and how are they realted to each other?