Problem 22 Create a query to find the balance characteristics for all customers, including the…
Create a query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.22.
Find the listing of customers who did not make purchases during the invoicing period. Sort the results by customer code. Your output must match the output shown in Figure P7.23.
Find the customer balance summary for all customers who have not made purchases during the current invoicing period. The results are shown in Figure P7.24.
Create a query that summarizes the value of products currently in inventory. Note that the value of each product is a result of multiplying the units currently in inventory by the unit price. Sort the results in descending order by subtotal, as shown in Figure P7.25.
Find the total value of the product inventory. The results are shown in Figure P7.26.