Question 4 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

Subject:Computer SciencePrice:9.82 Bought3

Share With

Question 4 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. Do not limit the results to only those first letters that occur in the last_name colum of the customer table but return results that include any missing letters from the data set. (HINT: You will need to fabricate a table composed of the 26 letters of the alphabet and use an outer join to resolve this problem.) 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 DOOPOOOONOOOPNPOPOOPONOWON 26 rows in set (0.00 sec)