Aggregation — Practice Questions
33 free PYSPARK and SQL challenges on Aggregation, auto-graded in the browser. Each states the problem, shows the input and expected output, and explains the answer.
- Find Duplicate Emails — Easy · SQL · +50 XP
- HR: Average Salary by Department — Easy · SQL · +50 XP
- Logistics: Count Shipments by Status — Easy · SQL · +50 XP
- Count Total Orders Placed by Each Customer — Easy · SQL · +50 XP
- Find Average Order Amount for Each Customer — Easy · SQL · +50 XP
- Find Customers Who Placed More Than 5 Orders (HAVING) — Easy · SQL · +50 XP
- Find the Most Recent Order Date for Each Customer — Easy · SQL · +50 XP
- Find Customers Who Spent More Than ₹1000 in Total (HAVING SUM) — Easy · SQL · +50 XP
- Find the Customer Who Placed the Most Orders — Easy · SQL · +50 XP
- Top 5 Customers by Total Amount Spent — Easy · SQL · +50 XP
- Departments With More Than 2 Employees (HAVING) — Easy · SQL · +50 XP
- Top 5 Best-Selling Products by Quantity Sold — Easy · SQL · +50 XP
- Find the Average Rating of Each Product — Easy · SQL · +50 XP
- Total Sales Amount by Each Customer — Easy · SQL · +50 XP
- Peak Sales Day and Its Share of Total — Easy · SQL · +50 XP
- Peak Sales Day and Its Share of Total (PySpark) — Easy · PYSPARK · +50 XP
- First Order Date per Customer — Easy · SQL · +50 XP
- First Order Date per Customer (PySpark) — Easy · PYSPARK · +50 XP
- Aggregate Daily Toll Revenue — Easy · PYSPARK · +75 XP
- Rolling 30-Day Active Customers — Hard · SQL · +150 XP
- Rolling 30-Day Active Customers (PySpark) — Hard · PYSPARK · +150 XP
- D1, D7 and D30 Retention per User — Hard · SQL · +150 XP
- D1, D7 and D30 Retention per User (PySpark) — Hard · PYSPARK · +150 XP
- Monthly Customer Churn Count — Hard · SQL · +150 XP
- Monthly Customer Churn Count (PySpark) — Hard · PYSPARK · +150 XP
- Departments With Many Employees AND High Average Salary — Medium · SQL · +100 XP
- Number of Orders by Each Customer per Month — Medium · SQL · +75 XP
- Month-over-Month Average Order Value — Medium · SQL · +100 XP
- Month-over-Month Average Order Value (PySpark) — Medium · PYSPARK · +100 XP
- Cumulative Active Users Over Time — Medium · SQL · +100 XP
- Cumulative Active Users Over Time (PySpark) — Medium · PYSPARK · +100 XP
- Daily Toll Revenue by Vehicle Type — Medium · SQL · +150 XP
- Optimize Large-Scale Event Processing — Medium · PYSPARK · +150 XP