#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2012
    Posts
    1
    Rep Power
    0

    SQL PLUS Query HELP!! + REWARD


    Hey I have a SQL project due tomorrow and I have to get these 5 queries done on the tables and inserts I have created.

    Here they are:

    1. What is the highest average amount of Sales Order per Customer?
    What is the lowest average amount of Sales Order per Customer?

    2. List all Sales Orders that still have not been paid.

    3. List phone # of all vendors who have not shipped our orders yet.

    4. Show a list of accounts receivable by days aging and the amount due.

    5. Which person has purchased a product the most times?

    These are pretty hard queries but I will reward the person who can help me with them. I can also send you the .sql file!!!

    Thanks
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,280
    Rep Power
    4279
    because of the reward inducement, i'm moving your thread to the "project help" forum

    good luck
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. Devshed Beginner (1000 - 1499 posts)

    Join Date
    Jan 2004
    Location
    New Springfield, OH
    Posts
    1,250
    Rep Power
    1469
    Originally Posted by pjung
    Hey I have a SQL project due tomorrow and I have to get these 5 queries done on the tables and inserts I have created.

    Here they are:

    1. What is the highest average amount of Sales Order per Customer?
    What is the lowest average amount of Sales Order per Customer?

    2. List all Sales Orders that still have not been paid.

    3. List phone # of all vendors who have not shipped our orders yet.

    4. Show a list of accounts receivable by days aging and the amount due.

    5. Which person has purchased a product the most times?

    These are pretty hard queries but I will reward the person who can help me with them. I can also send you the .sql file!!!

    Thanks
    Actually, none of these are particularly difficult tasks if you've set up your tabels correctly.

    Oh, and you might get better response if you told them what the reward was.

    Oh, and posted your DB diagram since no one has the slightest clue what you're working with. We're not magicians.
    Don't like me? Click it.

    Scripting problems? Windows questions? Ask the Windows Guru!

    Stay up to date with all of my latest content. Follow me on Twitter!

    Help us help you! Post your exact error message with these easy tips!
  6. #4
  7. CSS & JS/DOM Adept
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jul 2004
    Location
    USA (verifiably)
    Posts
    20,131
    Rep Power
    4304
    Welcome to DevShed Forums, pjung.

    I won't do it for you, since you need to learn to do it yourself, but I'll give you one tip.

    For #1 you're looking for the minimum and maximum. Here is the MySQL documentation for the functions to find those.

    P.S. We'd appreciate it if next time you tell us that you've asked your question elsewhere.
    Spreading knowledge, one newbie at a time.

    Check out my blog. | Learn CSS. | PHP includes | X/HTML Validator | CSS validator | Common CSS Mistakes | Common JS Mistakes

    Remember people spend most of their time on other people's sites (so don't violate web design conventions).

IMN logo majestic logo threadwatch logo seochat tools logo