question archive 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
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
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)
Purchase A New Answer
Custom new solution created by our subject matter experts
GET A QUOTE
Answer Preview
Please check the correct answer below.
Step-by-step explanation
SELECT starts_with(LEFT(word,1))+LOWER(SUBSTRING(word,2,LEN(word))), active_count, inactive_count FROM Customer where (select count(*) from Customer >30));
