10.12 (Aggregation with grouping) Based on the plumbing supply store database from Chapter 7, write SQL queries to perform the following tasks: A For each customer, show the Customer ID, first name, last name, and the total number of orders placed. B Show the same information about customers as in part (a), but count only orders placed since April 28, 2013; if a customer has placed no orders since that time, they need not appear in the output. C Show the same information as in part (b), but also include the date of each customers most recent order. D For each product, show its name and average quantity ordered when it appears in orders placed by customers from New Jersey (state code NJ).