SQL GROUP BY forcing a column in aggregate that I don’t need
I’m working on a report that we need to find all the products we sold by territory for a specific period. I got my report to work but as soon as I add my date column so I can filter on this my report is not giving my expected result as it wants to date column in the group by.