I have a complex query where I'm grouping by different items. To keep the grouping separate, I'm using partition over by clause.