SQL practice: Aggregate Functions
Chapter 9 · 10 questions · included in full access
Question 1 · easy
Solve it in your browserHow many employees are there?
Question 2 · easy
Solve it in your browserWhat is the most expensive product's price?
Question 3 · medium
Solve it in your browserWhat is the total quantity across all of order_items?
Question 4 · medium
Solve it in your browserWhat is the average salary in the company?
Question 5 · medium
Solve it in your browserHow many orders are Delivered?
Question 6 · medium
Solve it in your browserHow many different products have ever been ordered?
Question 7 · medium
Solve it in your browserWhat is the cheapest and most expensive product price, in one query?
Question 8 · medium
Solve it in your browserWhat is the total revenue of all order lines (quantity × unit price)?
Question 9 · hard
Solve it in your browserHow many branches are there, and how many different regions do they cover? (One query, two numbers.)
Question 10 · hard
Solve it in your browserThis query tries to find the percentage of products in each category, but integer division rounds it to 0. 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