Challenges
Featured Challenges
Selecting Salaries
Easy
Joining Departments
Medium
Advanced Aggregations
Hard
All Challenges
Title | Difficulty | Description | |
---|---|---|---|
Selecting Salaries | Practice writing simple SELECT queries. | ||
Joining Departments | Combine data from multiple tables using JOINs. | ||
Advanced Aggregations | Master complex aggregations and grouping operations. | ||
Filtering Records by Date | Learn to filter records based on a date range. | ||
Top Customers by Spending | Identify the customers who have spent the most money. | ||
Group By Product Category | Use GROUP BY to summarize data by category. | ||
Counting Employees per Department | Use COUNT and GROUP BY to summarize data. | ||
Calculating Total Sales | Practice using aggregate functions to calculate totals. | ||
Average Salary by Department | Use GROUP BY to calculate averages by department. | ||
Customer Orders | Learn how to join tables and group data. | ||
Employees with Salaries Above Average | Use subqueries to filter results based on an average. | ||
Products Above Average Price | Practice filtering results based on a calculated average. | ||
Highest Spending Customer | Use aggregate functions and joins to calculate total spending per customer. |