Topic Focus
Group-By Interview Problems (11)
Practice group-by questions asked in data science interviews
| Status | Title | Difficulty | |||
|---|---|---|---|---|---|
| Average Rating Per Product Category Pro | Easy | ||||
| Count by Department Free | Easy | ||||
| Count Orders Per Customer Free | Easy | ||||
| Count Orders Per Status Pro | Easy | ||||
| Sum and Average by Category Pro | Easy | ||||
| Unlock all 11+ problems | |||||
| Average Salary by Department Pro | Medium | ||||
| Departments With Average Salary Over 80000 Pro | Medium | ||||
| Group By with HAVING on MIN/MAX Pro | Medium | ||||
| Multiple Aggregations with HAVING Pro | Medium | ||||
| Grouping with Rollup-style Totals Pro | Hard | ||||
| Unlock all 11+ problems | |||||
| Revenue Contribution by Region With Rollup Pro | Hard | ||||