5.

How many orders were placed by each customer

? List the customer_name and the

total number of orders

for each customer

and order the results in ascending order of

the customer name.

Use the join facility to answer this question; do not use

subqueries

.

6.

What is the total quantity of the

products

with a

natural ash

finish

ordered by

customers in each state

? Only include states with a total quantity

of at least 5

and

order

the results in the descending order of customer state.

Use the join facility to

answer this question; do not use subqueries

.

HINT for #7: You might find this useful to answer #7

-

Which product(s) have the lowest price?

This calls for a subquery.