COUNT / SUM / AVG
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
Loading editor…
Expected output
60
When to use?
Summary/statistics.