Question 5 5 pts Write a query that returns the alphabetized first letter of the customer's last name and the count of active and inactive customers for only those letters where the count of active customers is greater than 30

Subject:Computer SciencePrice:9.82 Bought3

Share With

Question 5 5 pts Write a query that returns the alphabetized first letter of the customer's last name and the count of active and inactive customers for only those letters where the count of active customers is greater than 30. Label the columns as follows: starts_with is the first column and the first letter of the customer's last_name. . active count is the second column and the count of active customers (as defined in the textbook examples of Chapter 11). . inactive_count is the third column and the count of inactive customers (as defined in the textbook examples of Chapter 11). The output should look like the following: +- - -+ starts with | active count | inactive count B 55 C 49 G 42 INOPW H 49 M 57 R 38 S 54 PO 37 +- 8 rows in set (0.00 sec)