Comment by MattBlissett

With the GROUPING SETS or CUBE features in DuckDB, I think.

https://duckdb.org/docs/current/sql/query_syntax/grouping_se...