Grouping

:COUNT * FROM Entity GROUP BY field
:SUM field FROM Entity GROUP BY field
:AVG field FROM Entity GROUP BY field

:COUNT * FROM User GROUP BY status

:SUM amount FROM Order GROUP BY status

:AVG price FROM Product GROUP BY category

:MIN price FROM Product GROUP BY category
:MAX price FROM Product GROUP BY category

:GET Order WITH status, SUM(amount) AS total GROUP BY status

:SUM amount FROM Order GROUP BY status, user_id

:COUNT * FROM User GROUP BY status HAVING COUNT(*) > 10

:SUM amount FROM Order WHERE created_at > "2024-01-01" GROUP BY status HAVING SUM(amount) > 1000

:COUNT * FROM Product GROUP BY category ORDER BY count DESC

:SUM amount FROM Order 
  WHERE created_at BETWEEN "2024-01-01" AND "2024-12-31"
  GROUP BY status
  HAVING SUM(amount) >= 500
  ORDER BY sum DESC
  LIMIT 100