We mainly use GROUP BY with aggregate functions, like AVG(), SUM(), or COUNT() like in our example.
GROUP BY
AVG()
SUM()
COUNT()
Make sure to pick COUNT followed by ( and then *, ).
COUNT
(
*
)