help with SQL Plus Queries!!!!! (reward)

pjung · 05-09-2012, 02:03 AM

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

Fumigator · 05-09-2012, 04:30 AM

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)

guelphdad · 05-09-2012, 02:32 PM

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.

Old Pedant · 05-09-2012, 08:14 PM

Quote:

Originally Posted by pjung

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"?

Fou-Lu · 05-09-2012, 10:03 PM

Quote:

Originally Posted by Old Pedant

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