MIN, MAX, COUNT, SUM and AVG.
✍️ 3 exercises + code challenge in this lessonAggregate functions calculate one value from many rows:
COUNT(): number of rows (COUNT(*) counts all; COUNT(column) ignores NULLs).SUM(): total.AVG(): average.MIN() / MAX(): smallest / largest.Combine them with GROUP BY (a later lesson) to get one result per group.
Mastering SQL Aggregate Functions helps you write clean and reliable SQL code. Follow standard conventions, test edge cases, and keep logic simple. Try running the code example below and complete the exercises to build confidence.
SELECT COUNT(*) AS Products,
MIN(Price) AS Cheapest,
MAX(Price) AS MostExpensive,
ROUND(AVG(Price), 0) AS AveragePrice,
SUM(Stock) AS TotalStock
FROM Products;
SELECT COUNT(Email) AS CustomersWithEmail FROM Customers;Check what you learned in “SQL Aggregate Functions”.
Count the rows in Orders.
SELECT (*) FROM Orders;
Which function returns the average?
Select the total stock of all products as TotalStock.
Free sign-in required · Google login available
Stuck on something?
Ask the community in the CodesInTech forum.
Need a developer?
Learning on your own is great — and when you need professional help, our team builds custom software, websites and mobile apps for clients worldwide.
Explore Our Services