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.

1) Rewrite the query below to use GROUP BY CUS_CODE :   SELECT CUSTOMER.CUS_CODE, CUSTOMER.CUS_LNAME, INVOICE.INV_NUMBER, INVOICE.INV_DATEFROM CUSTOMER INNER JOIN INVOICE ON CUSTOMER.CUS_CODE = INVOICE.CUS_CODE;   2) Rewrite the query below to include line items of each invoice :   SELECT CUSTOMER.CUS_CODE, CUSTOMER.CUS_LNAME, INVOICE.INV_NUMBER, INVOICE.INV_DATEFROM CUSTOMER INNER JOIN INVOICE ON CUSTOMER.CUS_CODE = INVOICE.CUS_CODE;   3) Rewrite the query from 2) to show only the customers who bought a product priced higher than $100, which product, what price, how many units, and when.

Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on the Sundays of July 2015—grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description.  This is what Ive been working with and doesn't give me results, just error messages.  SELECT R.CreditDescription, E.CustomerID FROM Encounter E JOIN Customer C ON E.CustomerID = C.CustomerID JOIN CreditRating R ON C.CreditID = R.CreditID WHERE E.EncDate = STR_TO_DATE('2015-07-05','2015-07-12','2015-07-19','2015-07-26'); ORDER BY creditrating.creditid, ASC;   creditrating creditid creditdescription minfico maxfico comments customer customerid cfirstname clastname…

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. make sure the decimal are the same