Write a query to generate the total number of invoices, the invoice total for all of the invoices, the smallest of the customer purchase amounts, the largest of the customer purchase amounts, and the average of all the customer purchase amounts. Your output must match Figure P7.19.   subquery to use from 18: SELECT DISTINCT INVOICE.CUS_CODE, COUNT(DISTINCT INVOICE.INV_NUMBER) AS "Number of Invoices", ROUND(SUM(LINE_PRICE*LINE_UNITS),2) AS "Total Customer Purchases" FROM CUSTOMER, INVOICE, LINE WHERE CUSTOMER.CUS_CODE=INVOICE.CUS_CODE AND INVOICE.INV_NUMBER=LINE.INV_NUMBER GROUP BY INVOICE.CUS_CODE ORDER BY INVOICE.CUS_CODE;

From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);

From invoices table, write a query to retrieve everything (all columns), plus, add an additional column that retrieves difference in the number of days between the invoice due date and paymentdate, and name the column “Difference”. Note that the difference in days should be calculated bysubtracting “payment_date” from “invoice_due_date”.Hint1, refer to the following sample:... Invoice Due Date Payment Date Difference... 2018-05-08 2018-05-07 1... 2018-05-10 2018-05-14 -4... 2018-05-13 2018-05-09 4Hint 2: simple subtraction or DATEDIFF function. Both works.

Create a query to calculate Quantity_Sold * Sale_Price and compare the calculated value to Sale_Amt by calculating the difference to ensure it is zero