Hello @adityavichare1,
Check out this nice youtube video on the GROUP command. I think this is what you are looking for.
https://www.youtube.com/watch?v=z4i0TViShnc
If this helps you then hit the LIKE button or mark as an ACCEPTED SOLUTION!
Thank You!
Jonathan Focht
