Revisiting GROUP BY ROLLUP with a more realistic example

Ever had a random piece of knowledge from school suddenly click in a real-world scenario? It felt like that for me remembering about ROLLUP a few days ago. I wrote about GROUP BY ROLLUP roughly 1.5 years ago—one of my first posts here. At the time, i...