Exercises
Advanced SQL CASE WHEN Exercises
Advanced-level SQL CASE WHEN practice exercises with solutions. Exercise 1 Question: Count orders by status (Pending, Shipped, Delivered). sql SELECT...
Start practicing →
Free SQL Practice
SQL Exercises with Answers
Practice SQL from beginner to advanced with our curated exercises. Each problem includes table schemas, solutions, and explanations.
100+
Exercises
13
Topics
3
Difficulty Levels
100%
Free
Browse by Topic
Exercises
Advanced SQL Common Table Expressions (CTEs) Exercises
Advanced-level SQL Common Table Expressions (CTEs) practice exercises with solutions. Exercise 1 Question: Use a CTE to find employees with above-ave...
Start practicing →
Exercises
Advanced SQL GROUP BY Exercises
Advanced-level SQL GROUP BY practice exercises with solutions. Exercise 1 Question: Find total revenue by product category and month. sql SELECT p...
Start practicing →
Exercises
Advanced SQL INNER JOIN Exercises
Advanced-level SQL INNER JOIN practice exercises with solutions. Exercise 1 Question: List employees with their manager's name using a self-join. sql...
Start practicing →
Exercises
Advanced SQL Subqueries Exercises
Advanced-level SQL Subqueries practice exercises with solutions. Exercise 1 Question: Find the second highest salary in the company. sql SELECT MAX(s...
Start practicing →
Exercises
Advanced SQL Window Functions Exercises
Advanced-level SQL Window Functions practice exercises with solutions. Exercise 1 Question: Rank employees by salary within each department. sql SELE...
Start practicing →
Exercises
Intermediate SQL CASE WHEN Exercises
Intermediate-level SQL CASE WHEN practice exercises with solutions. Exercise 1 Question: Categorize employees by salary range (Low, Medium, High). sq...
Start practicing →
Exercises
Intermediate SQL GROUP BY Exercises
Intermediate-level SQL GROUP BY practice exercises with solutions. Exercise 1 Question: Count the number of employees in each department. sql SELECT ...
Start practicing →
Exercises
Intermediate SQL HAVING Clause Exercises
Intermediate-level SQL HAVING Clause practice exercises with solutions. Exercise 1 Question: Find departments with more than 5 employees. sql SELECT ...
Start practicing →
Exercises
Intermediate SQL INNER JOIN Exercises
Intermediate-level SQL INNER JOIN practice exercises with solutions. Exercise 1 Question: Join employees with their departments to show employee name...
Start practicing →
Exercises
Intermediate SQL LEFT JOIN Exercises
Intermediate-level SQL LEFT JOIN practice exercises with solutions. Exercise 1 Question: List all employees and their departments, including employee...
Start practicing →
Exercises
Intermediate SQL Subqueries Exercises
Intermediate-level SQL Subqueries practice exercises with solutions. Exercise 1 Question: Find employees who earn more than the average salary. sql S...
Start practicing →
Exercises
Intermediate SQL WHERE Clause Exercises
Intermediate-level SQL WHERE Clause practice exercises with solutions. Exercise 1 Question: Find employees who are NOT in the Engineering or Marketin...
Start practicing →
Exercises
MySQL: Advanced SQL CASE WHEN Exercises
MySQL guide: Advanced-level SQL CASE WHEN practice exercises with solutions. Exercise 1 Question: Count orders by status (Pending, Shipped, Delivered). sql SELECT...
Start practicing →
Exercises
MySQL: Advanced SQL Common Table Expressions (CTEs) Exercises
MySQL guide: Advanced-level SQL Common Table Expressions (CTEs) practice exercises with solutions. Exercise 1 Question: Use a CTE to find employees with above-ave...
Start practicing →
Exercises
MySQL: Advanced SQL GROUP BY Exercises
MySQL guide: Advanced-level SQL GROUP BY practice exercises with solutions. Exercise 1 Question: Find total revenue by product category and month. sql SELECT p...
Start practicing →
Exercises
MySQL: Advanced SQL INNER JOIN Exercises
MySQL guide: Advanced-level SQL INNER JOIN practice exercises with solutions. Exercise 1 Question: List employees with their manager's name using a self-join. sql...
Start practicing →
Exercises
MySQL: Advanced SQL Subqueries Exercises
MySQL guide: Advanced-level SQL Subqueries practice exercises with solutions. Exercise 1 Question: Find the second highest salary in the company. sql SELECT MAX(s...
Start practicing →
Exercises
MySQL: Advanced SQL Window Functions Exercises
MySQL guide: Advanced-level SQL Window Functions practice exercises with solutions. Exercise 1 Question: Rank employees by salary within each department. sql SELE...
Start practicing →
Exercises
MySQL: Intermediate SQL CASE WHEN Exercises
MySQL guide: Intermediate-level SQL CASE WHEN practice exercises with solutions. Exercise 1 Question: Categorize employees by salary range (Low, Medium, High). sq...
Start practicing →
Exercises
MySQL: Intermediate SQL GROUP BY Exercises
MySQL guide: Intermediate-level SQL GROUP BY practice exercises with solutions. Exercise 1 Question: Count the number of employees in each department. sql SELECT ...
Start practicing →
Exercises
MySQL: Intermediate SQL HAVING Clause Exercises
MySQL guide: Intermediate-level SQL HAVING Clause practice exercises with solutions. Exercise 1 Question: Find departments with more than 5 employees. sql SELECT ...
Start practicing →
Exercises
MySQL: Intermediate SQL INNER JOIN Exercises
MySQL guide: Intermediate-level SQL INNER JOIN practice exercises with solutions. Exercise 1 Question: Join employees with their departments to show employee name...
Start practicing →
Exercises
MySQL: Intermediate SQL LEFT JOIN Exercises
MySQL guide: Intermediate-level SQL LEFT JOIN practice exercises with solutions. Exercise 1 Question: List all employees and their departments, including employee...
Start practicing →
Exercises
MySQL: Intermediate SQL Subqueries Exercises
MySQL guide: Intermediate-level SQL Subqueries practice exercises with solutions. Exercise 1 Question: Find employees who earn more than the average salary. sql S...
Start practicing →
Exercises
MySQL: Intermediate SQL WHERE Clause Exercises
MySQL guide: Intermediate-level SQL WHERE Clause practice exercises with solutions. Exercise 1 Question: Find employees who are NOT in the Engineering or Marketin...
Start practicing →
Exercises
MySQL: SQL CASE WHEN Exercises (With Answers)
MySQL guide: Learn SQL CASE WHEN with hands-on practice exercises. Each exercise includes the table schema, solution query, expected output, and detailed explanati...
Start practicing →
Exercises
MySQL: SQL Common Table Expressions (CTEs) Exercises (With Answers)
MySQL guide: Learn SQL Common Table Expressions (CTEs) with hands-on practice exercises. Each exercise includes the table schema, solution query, expected output, ...
Start practicing →
Exercises
MySQL: SQL GROUP BY Exercises (With Answers)
MySQL guide: Learn SQL GROUP BY with hands-on practice exercises. Each exercise includes the table schema, solution query, expected output, and detailed explanatio...
Start practicing →
Exercises
MySQL: SQL HAVING Clause Exercises (With Answers)
MySQL guide: Learn SQL HAVING Clause with hands-on practice exercises. Each exercise includes the table schema, solution query, expected output, and detailed expla...
Start practicing →
Showing 30 of 100 exercise pages
Want Interactive Practice?
Try our interactive SQL sandbox where you can run queries against real databases.
Open SQL Sandbox