Aggregate functions summarize several rows into one value: COUNT (number), SUM (sum), AVG (average), MIN and MAX (extremes). Without GROUP BY, they apply to the whole table and return one row. They ignore NULLs, except COUNT(*).
Example
SELECT COUNT(*), AVG(prix), MAX(prix) FROM produits;