Your question is Average Feedback Score by Office. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are given a table of feedback submissions from a McKinsey & internal platform. Write a SQL query to return each office_name and its average score, considering only submitted scores that are not NULL. Sort the results by average score in descending order, and then by office_name alphabetically.
| Column | Type | Description |
|---|---|---|
| submission_idPK | INT | Unique feedback submission ID |
| office_name | VARCHAR(100) | Office where the feedback was submitted |
| score | INT | Feedback score on a 1-5 scale; may be NULL |
| submitted_at | DATE | Date the feedback was submitted |