Question: Consider the following query: WITH number _ orders AS ( SELECT CustomerID, COUNT ( * ) AS order _ count FROM Customers GROUP BY CustomerID
Consider the following query:
WITH numberorders AS
SELECT CustomerID,
COUNT AS ordercount
FROM Customers
GROUP BY CustomerID
SELECT AVGordercount AS avgordercount
FROM numberorders
After we run the above query, what will be the output?
Group of answer choices
The average number of orders per customer.
The total number of orders grouped by CustomerID
The average number of orders grouped by CustomerID
The average number of customers who ordered products
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
