Assignment 9: LEFT JOIN + GROUP BY
-
>>Please produce a report which shows the number of customers that each Account manager has in TOP Customer Class sorting the output from highest to lowest (HINT: use LEFT JOIN, WHERE, GROUP and ORDER BY clauses). The report should have 2 columns Acount Manager and the number of clients.
-
>>print screen of the query and the report obtained both with code and report seen
-
<fac_num>_name_assignment.jpg (please remember to change the task name)
- https://forms.gle/BpCr8tBhX6Xx7Bow6
Last modified: Saturday, 26 March 2022, 3:59 PM