yes, thats exactly the way I feel. It might be the right answer, but oftentimes its a smell. Theres very few cases where you shouldnt be doing a group by with

yes, thats exactly the way I feel. It might be the right answer, but oftentimes its a smell. Theres very few cases where you shouldnt be doing a group by with aggregates instead. (window functions count here)