DEP003
Published 20 November 2017
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.