3 ms·

100% you should. All of what you have just described isnt very hard in SQL.. coalescing on null, aggregating, etc. GROUPING SETS() will give you your missing

100% you should. All of what you have just described isnt very hard in SQL.. coalescing on null, aggregating, etc. GROUPING SETS() will give you your missing rows.