I am a long-time user of SQL, but something that I never quite got to grips with was the use of the grouping sets, cube, and rollup functionality that modern SQL database systems introduced a number of years ago.
Part of the reason for that was probably because of the type of databases I was…