COUNT / SUM / AVG
Try it yourself →Counts/sums/averages rows.
Syntax
SELECT COUNT(*), SUM(column) FROM table;
Description
COUNT(*) is row count, SUM is total, AVG is average, MIN/MAX is minimum/maximum.
Example
CREATE TABLE k(price INTEGER); INSERT INTO k VALUES (10), (20), (30); SELECT SUM(price) FROM k;
Expected output
60
When to use?
Summary/statistics.