GROUP BY ALL clause is deprecated

GROUP BY ALL clause is not supported for remote tables and is no longer actively maintained.

Use a custom case-by-case solution with UNION or a derived table. The results you get are more intuitive: it is easier to know when a zero category will appear or not.

Didn't find what you were looking for?