Go Back   CodingForums.com > :: Server side development > MySQL > Other Databases

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 05-09-2012, 02:03 AM   PM User | #1
pjung
New to the CF scene

 
Join Date: May 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
pjung is an unknown quantity at this point
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
pjung is offline   Reply With Quote
Old 05-09-2012, 04:30 AM   PM User | #2
Fumigator
UE Antagonizer


 
Fumigator's Avatar
 
Join Date: Dec 2005
Location: Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
Posts: 7,686
Thanks: 42
Thanked 637 Times in 625 Posts
Fumigator is a glorious beacon of lightFumigator is a glorious beacon of lightFumigator is a glorious beacon of lightFumigator is a glorious beacon of lightFumigator is a glorious beacon of light
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)
__________________
Fumigator is offline   Reply With Quote
Old 05-09-2012, 02:32 PM   PM User | #3
guelphdad
Super Moderator


 
guelphdad's Avatar
 
Join Date: Mar 2006
Location: St. Catharines, Ontario Canada
Posts: 2,629
Thanks: 4
Thanked 147 Times in 138 Posts
guelphdad will become famous soon enoughguelphdad will become famous soon enough
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.
guelphdad is offline   Reply With Quote
Old 05-09-2012, 08:14 PM   PM User | #4
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,168
Thanks: 59
Thanked 3,993 Times in 3,962 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
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.
Old Pedant is offline   Reply With Quote
Old 05-09-2012, 10:03 PM   PM User | #5
Fou-Lu
God Emperor


 
Fou-Lu's Avatar
 
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Posts: 15,635
Thanks: 4
Thanked 2,448 Times in 2,417 Posts
Fou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to all
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
Fou-Lu is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 11:25 PM.


Advertisement
Log in to turn off these ads.