-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|