Assignment 5: GROUP BY
Your manager would like to analyze the Customer Classes (Bottom, Middle and TOP) and asked you to produce a report which can answer next questions:
-
How many customers are inside each class?
-
What is the average age of customers of each class?
-
What is the maximum age of customers of each class?
-
What is the minimum age of customers of each class?
-
How many different countries do customers represent in each class?
-
What is the number of managers having clients in each class?
-
Please give each column a good looking name for the report purposes.
-
print screen of the query and the report obtained
-
<fac_num>_name_assignment.jpg
- https://forms.gle/BpCr8tBhX6Xx7Bow6
Last modified: Wednesday, 23 March 2022, 2:47 PM