# Blog

- [CASE… WHEN… ELSE… END](/case-when-else-end) — Case… When.. Else… End maybe one of the most used SQL statements. Did you know you could use CASE with aggregate functions?
- [What is an aggregate function?](/what-is-an-aggregate-function) — An aggregate function where the values are grouped together to form a single response. The more common SQL aggregate functions are SUM, COUNT, AVG, MIN and MAX.