INNER JOIN
Intermediate
Employee Department Names
List each employee's full name alongside their department name. Use INNER JOIN. Return columns: first_name, last_name, department_name.
25 XPSolve challenge
Interactive SQL practice
Intermediate SQL Challenges
Work through 90 intermediate SQL exercises in a structured sequence. Each challenge includes a clear problem, schema context and an interactive query editor.
90 SQL challenges
Open Practice ArenaHAVING
Intermediate
Departments with High Average Salary
Find departments where the average salary is greater than 75,000. Return columns: department_id, avg_salary. Order results by: department_id.
25 XPSolve challenge
LEFT JOIN
Intermediate
Customers Without Orders
Find all customers who have never placed an order. Return columns: id, name, email.
25 XPSolve challenge
INNER JOIN
Intermediate
Revenue Per Customer
Calculate total revenue (sum of total_amount) per customer, showing customer name and total revenue, sorted by revenue descending. Return columns: customer_name, total_revenue. Order results by: total_revenue DESC.
25 XPSolve challenge
Subqueries
Intermediate
Employees Above Department Average
Find employees whose salary is higher than the average salary of their department. Return columns: first_name, last_name, salary, department_id.
25 XPSolve challenge
INNER JOIN
Intermediate
Product Sales Summary
For each product, show the total quantity sold and total revenue from order_items. Include product name. Return columns: product_name, total_quantity, total_revenue. Order results by: total_revenue DESC.
25 XPSolve challenge
Date Functions
Intermediate
Employee Hire Year Count
Count how many employees were hired in each year, ordered by year ascending. Return columns: hire_year, employee_count. Order results by: hire_year ASC.
25 XPSolve challenge
String Functions
Intermediate
Employee Full Name Concatenation
Create a full_name column by concatenating first_name and last_name with a space between them. Return columns: full_name, email.
25 XPSolve challenge
INNER JOIN
Intermediate
Department Payroll Summary
Show each department name, employee count, and total payroll. Return columns: department_name, employee_count, total_payroll. Order results by: d.id.
25 XPSolve challenge
LEFT JOIN
Intermediate
Department Employee Coverage
Show all departments and their employee count, including departments with no employees. Return columns: department_name, employee_count. Order results by: d.id.
25 XPSolve challenge
GROUP BY
Intermediate
Order Status Summary
Show the order count and total amount for each status. Return columns: status, order_count, total_amount. Order results by: status.
25 XPSolve challenge
HAVING
Intermediate
Repeat Customers
Find customers who placed more than one order. Return columns: customer_name, order_count. Order results by: order_count DESC, customer_name.
25 XPSolve challenge
LEFT JOIN
Intermediate
Product Revenue Including Unsold
Show every product and its revenue, using zero when it has no sales. Return columns: product_name, revenue. Order results by: p.id.
25 XPSolve challenge
INNER JOIN
Intermediate
Employee and Manager Names
List each managed employee together with their manager's name. Return columns: employee, manager. Order results by: e.id.
25 XPSolve challenge
Subqueries
Intermediate
Orders Above Average Value
Find orders whose total amount is greater than the average order value. Return columns: id, customer_id, total_amount. Order results by: total_amount DESC.
25 XPSolve challenge
String Functions
Intermediate
Employee Email Usernames
Extract the portion of each employee email before the @ symbol. Return columns: email, username. Order results by: id.
25 XPSolve challenge
Date Functions
Intermediate
Monthly Completed Revenue
Calculate completed-order revenue for each month. Return columns: month, revenue. Order results by: month.
25 XPSolve challenge
Aggregations
Intermediate
Low Stock Value
Calculate inventory value for products with fewer than 200 units. Return columns: name, stock, price, inventory_value. Order results by: inventory_value DESC.
25 XPSolve challenge
WHERE
Intermediate
Department 1 Salary Filter 80000
Find employees in department 1 earning at least 80000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
Department 1 Salary Filter 90000
Find employees in department 1 earning at least 90000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
PRO
Department 2 Salary Filter 60000
Find employees in department 2 earning at least 60000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
PRO
Department 2 Salary Filter 70000
Find employees in department 2 earning at least 70000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
PRO
Department 3 Salary Filter 65000
Find employees in department 3 earning at least 65000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
PRO
Department 3 Salary Filter 70000
Find employees in department 3 earning at least 70000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
PRO
Department 4 Salary Filter 50000
Find employees in department 4 earning at least 50000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
PRO
Department 5 Salary Filter 90000
Find employees in department 5 earning at least 90000. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
String Functions
Intermediate
Employee Names Starting With A
Find employees whose first name starts with A. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
Employee Names Starting With B
Find employees whose first name starts with B. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Starting With C
Find employees whose first name starts with C. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Starting With D
Find employees whose first name starts with D. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Starting With E
Find employees whose first name starts with E. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Starting With F
Find employees whose first name starts with F. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Starting With G
Find employees whose first name starts with G. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Starting With H
Find employees whose first name starts with H. Return columns: first_name, last_name, email. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
Employee Names Containing a
Find employee full names containing the letter a, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
Employee Names Containing b
Find employee full names containing the letter b, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Containing c
Find employee full names containing the letter c, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Containing d
Find employee full names containing the letter d, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Containing e
Find employee full names containing the letter e, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Containing i
Find employee full names containing the letter i, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Containing l
Find employee full names containing the letter l, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
String Functions
Intermediate
PRO
Employee Names Containing o
Find employee full names containing the letter o, case-insensitively. Return columns: first_name, last_name. Order results by: first_name.
25 XPSolve challenge
ORDER BY
Intermediate
Top 1 Salaries
Return the 1 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
Top 2 Salaries
Return the 2 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Top 3 Salaries
Return the 3 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Top 4 Salaries
Return the 4 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Top 5 Salaries
Return the 5 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Top 6 Salaries
Return the 6 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Top 7 Salaries
Return the 7 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Top 8 Salaries
Return the 8 highest-paid employees. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
Salary Ranking Page 1
Return two employees from salary ranking page 1. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
Salary Ranking Page 2
Return two employees from salary ranking page 2. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Salary Ranking Page 3
Return two employees from salary ranking page 3. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Salary Ranking Page 4
Return two employees from salary ranking page 4. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Salary Ranking Page 5
Return two employees from salary ranking page 5. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Salary Ranking Page 6
Return two employees from salary ranking page 6. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Salary Ranking Page 7
Return two employees from salary ranking page 7. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
ORDER BY
Intermediate
PRO
Salary Ranking Page 8
Return two employees from salary ranking page 8. Return columns: first_name, last_name, salary. Order results by: salary DESC, id.
25 XPSolve challenge
WHERE
Intermediate
Products Priced Above 50
List products priced above 50, most expensive first. Return columns: name, category, price. Order results by: price DESC, id.
25 XPSolve challenge
WHERE
Intermediate
Products Priced Above 100
List products priced above 100, most expensive first. Return columns: name, category, price. Order results by: price DESC, id.
25 XPSolve challenge
Showing the first 60 of 90 challenges in this learning path.
Browse and filter all challenges in the Practice ArenaLevel guide
What to expect from intermediate SQL exercises
Intermediate SQL challenges combine tables and business rules with JOINs, grouped reports, subqueries and reusable CTEs.
- Choose join keys without multiplying rows
- Define the grain before grouping
- Break multi-step logic into testable query stages