Chapter 3, Problem 1.4CP

Measured by average standard price, what is the least expensive product finish?

Write the Excel function to determine the number of salespersons who had a Sales Total above the given “Average Sales Total”?

Referring to the diagram above, which GROUP BY statement would best match the SELECT statement of "SELECT s.CustomerID, s.SaleDate, s.SalesInvoiceID, SUM(Quantity*SoldPrice) AS OrderTotal"? a   GROUP BY s.CustomerID, s.SaleDate, s.SalesInvoiceID b   GROUP BY OrderTotal. c   GROUP BY s.SaleDate d   GROUP BY s.SalesInvoiceID Select the best option.