Results 1 to 2 of 2

Thread: Query Help needed

  1. #1
    Join Date
    Apr 2011
    Posts
    0

    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

  2. #2
    Join Date
    Feb 2011
    Location
    Melbourne, Australia
    Posts
    13
    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
  •