Now modify the above query to also include those orders for which no payment has yet been received. List again the results in decreasing order of the difference between total due and amount paid. Display a list of total quantity sold (label as TotSales) for each salesperson state and product finish. Null values for State should be substituted with ‘Unknown State’ and Null values for product finish should be substituted with ‘Unknown Finish’.

Display the customer ID and name for the customers who bought at least one product that belongs to product line Basic in March. List each customer once.

A. Now modify the above query to include the number of products bought that belongs to product line Basic in March.

B. Now restrict your results to those customers who have bought more than 2 such products

C. And now list all customers and for those customers that have never bought such product report 0. To do so you cannot just use an outer join (but you can try and this way you will see why not). To get this result you can use subqueries or you can use UNION, INTERSECT, or MINUS.