1. SELECT AGG_FUNC(column_or_expression) AS aggregate_description, …
    2. FROM mytable
    3. WHERE constraint_expression
    4. GROUP BY column;

    image.png

    1. SELECT role, COUNT(name),building IS NULL AS bn
    2. FROM employees
    3. GROUP BY role, bn