Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A company has the following dataset in the database. CUSTOMER ID NAME CITY STATE 100558 Bentonville AR 100623 Walmart Target Trader Joe's MN 100879 Minneapolis
A company has the following dataset in the database. CUSTOMER ID NAME CITY STATE 100558 Bentonville AR 100623 Walmart Target Trader Joe's MN 100879 Minneapolis Monrovia Bentonville CA 100950 Sam's Club AR Assume that your manager asked you to count the number of customers in each state for further reporting purposes. Please name the new count variable as NO_OF_CUSTOMER and also sort the results by the state in descending order. After this process, you will get the following summary table: STATE NO OF CUSTOMER MN 1 CA 1 AR 2 If you are using Microsoft SQL Server Management Studio, what would be the SQL queries to get this summary table? (Note: Please use all CAPITAL LETTERS for the SQL queries. For example, use "SELECT", instead of "select" or "Select".)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started