A solution for last week's challenge can be found here.
For this week's challenge, you are provided two datasets:
- The first one (Clients) contains each client's information including their Client ID
- The second one (Request & Evaluation) contains the client's Request number (which is the same as the Client ID), "Status" which indicates if the request has been processed, "Status2" provides a comment, and the "Professional" field is the name of the customer.
Your tasks are to determine:
- For a "Status" of Evaluated, the number of customers ("Professional") who commented "Below Expectations", "Exceeded Expectations", or "Met Expectations" for "Status2"
- The three customers ("Professional") who provided the highest average rating