Challenges

Featured Challenges

Selecting Salaries

Easy

Joining Departments

Medium

Advanced Aggregations

Hard

All Challenges

TitleDifficultyDescription
Selecting SalariesPractice writing simple SELECT queries.
Joining DepartmentsCombine data from multiple tables using JOINs.
Advanced AggregationsMaster complex aggregations and grouping operations.
Filtering Records by DateLearn to filter records based on a date range.
Top Customers by SpendingIdentify the customers who have spent the most money.
Group By Product CategoryUse GROUP BY to summarize data by category.
Counting Employees per DepartmentUse COUNT and GROUP BY to summarize data.
Calculating Total SalesPractice using aggregate functions to calculate totals.
Average Salary by DepartmentUse GROUP BY to calculate averages by department.
Customer OrdersLearn how to join tables and group data.
Employees with Salaries Above AverageUse subqueries to filter results based on an average.
Products Above Average PricePractice filtering results based on a calculated average.
Highest Spending CustomerUse aggregate functions and joins to calculate total spending per customer.
Disclaimer: This website is not affiliated with Michigan State University.