SQL practice: Subqueries
Chapter 16 · 9 questions · included in full access
Question 1 · easy
Solve it in your browserFind products costing more than the average product price.
Question 2 · easy
Solve it in your browserFind customers who have at least one Cancelled order.
Question 3 · medium
Solve it in your browserFind employees earning more than the company average salary.
Question 4 · medium
Solve it in your browserFind products that cost more than the most expensive Accessory.
Question 5 · medium
Solve it in your browserFind branches whose order count is above 5, using a subquery in FROM.
Question 6 · medium
Solve it in your browserFind the customer(s) who placed the very first order (earliest order_date).
Question 7 · medium
Solve it in your browserFind employees whose salary equals the maximum salary in the company.
Question 8 · hard
Solve it in your browserFind all orders placed on the same date as order 1.
Question 9 · hard
Solve it in your browserFind products that cost more than every Adhesive. The query fails with 'more than one row returned by a subquery'. Fix it.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing