This query is similar to query 3.2, but uses implicit grouping.
Implicit grouping occurs when at least one aggregation function is used (in this case
count) and no
group by clause is given. In this case, grouping is performed based on the set of visible variables that are not themselves arguments to an aggregation function. In this query, implicit grouping result in grouping around the