Topic
Aggregation problems
38 problems: 19 Easy, 15 Medium, 4 Hard.
Easy (19)
- Count Employees Per Department
- Find Duplicate Emails
- Delete Duplicate Emails
- Product Sales Analysis
- Top Travellers
- Group Sold Products
- User Activity Count
- Queries Quality and Percentage
- Ads Performance
- Find Team Size
- Daily Leads and Partners
- Actors and Directors
- Biggest Single Number
- Classes More Than 5 Students
- Game Play Analysis
- Library Title Search Ranking
- Copies With Multiple Open Loans
- Services Whose Direct Dependencies Exceed Project Budget
- Retargeting Parent Revenue Rollup
Medium (15)
- Second Highest Salary
- Department Highest Salary
- Rank Scores
- Managers With 5+ Reports
- Winning Candidate
- Monthly Transactions
- Immediate Food Delivery
- Cumulative Sum of Sales
- Revenue By Product
- Average Salary By Department
- Distinct Products Sold Per Day
- Orders and Revenue Per Product
- Single-Pass Playback Sessionization
- Quota Overage Versus Invoiced Units Reconciliation
- Time-Scoped Meter Visibility Report