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.
Display the order IDs for customers who have not made any payment, yet, on that order. Use the set command UNION, INTERSECT, or MINUS in your query
Display the names of the states in which customers reside but for which there is no salesperson residing in that state. Write this query two ways, using the set command UNION, INTERSECT, or MINUS and not using any of these commands.
List the Ids and names of those sales territories that have at least 50% more customers as the average number of customers per territory.
List the salesperson who has sold the most computer descs (Hint: you will need a subquery).
For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer to the total number of orders from all customers combined. (This ratio, of course, is the percentage of all orders placed by each customer.)
List the average of the number of customers per state (including only the states that are included in the Customer_T table). Hint: You are asked to find x in the statement: On average there are x customer in each state. You are not asked to report the number of customers in every state.