Aggregate function

Ko‘p qatordan bitta qiymat hisoblovchi funksiya: COUNT, SUM, AVG, MIN, MAX. GROUP BY bilan har guruh uchun alohida hisoblanadi.

SELECT category, COUNT(*) FROM dishes GROUP BY category;