SQL practice: Mock Test
Chapter 35 · 10 questions · included in full access
Question 1 · hard
Solve it in your browserList all branches that have never had an order.
Question 2 · hard
Solve it in your browserFind the top 3 products by total revenue.
Question 3 · hard
Solve it in your browserCount the orders per month.
Question 4 · hard
Solve it in your browserFind all employees who earn more than their own manager.
Question 5 · hard
Solve it in your browserFind customers who have never ordered.
Question 6 · hard
Solve it in your browserFind the 2nd highest salary in the company.
Question 7 · hard
Solve it in your browserFor each branch, find its single highest-value order.
Question 8 · hard
Solve it in your browserFor each customer, find the average number of days between their orders.
Question 9 · hard
Solve it in your browserShow every branch's revenue and what percent of total company revenue it represents.
Question 10 · hard
Solve it in your browserFind the best-selling product in each branch — one row per branch.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing