>SELECT land, stadt, abteilung, count(*) FROM personal GROUP BY ROLLUP (land, stadt, abteilung) ORDER BY 1, 2, 3;
 -------------------+-----------+-------+
 | land |   stadt   | abteilung | count |
 -------------------+-----------+-------+
 | AT   | Innsbruck | Personal  |     1 |
 | AT   | Innsbruck |           |     1 |
 | AT   |           |           |     1 |
 | CH   | Zürich    | Vertrieb  |     1 |
 | CH   | Zürich    |           |     1 |
 | CH   |           |           |     1 |
 | DE   | Berlin    | Marketing |     1 |
 | DE   | Berlin    | Vertrieb  |     1 |
 | DE   | Berlin    |           |     2 |
 | DE   | Frankfurt | Vertrieb  |     1 |
 | DE   | Frankfurt |           |     1 |
 | DE   |           |           |     3 |