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

because of the reward inducement, i'm moving your thread to the "project help" forum

good luck

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.

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.