Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    May 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    help with SQL Plus Queries!!!!! (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
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    There's a rule here at Coding Forums against posting your homework and expecting someone else to do it for you. Some might even consider it unethical! (shocker)

  • #3
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,634
    Thanks
    4
    Thanked 148 Times in 139 Posts
    That rule exists on almost any forum. If you aren't willing to show what you have attempted you aren't going to get assistance with homework.

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,596
    Thanks
    80
    Thanked 4,633 Times in 4,595 Posts
    Quote Originally Posted by pjung View Post
    These are pretty hard queries...
    If you think those are pretty hard queries, then you probably better get out of the programming business.

    And, hey, GuelphDad and Fumigator: This is posted in the wrong forum, on top of everything else. Notice he said "SQL Plus"?
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #5
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,994
    Thanks
    4
    Thanked 2,662 Times in 2,631 Posts
    Quote Originally Posted by Old Pedant View Post
    If you think those are pretty hard queries, then you probably better get out of the programming business.

    And, hey, GuelphDad and Fumigator: This is posted in the wrong forum, on top of everything else. Notice he said "SQL Plus"?
    O.o
    Moving to Other Databases forum


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •