I think there's a missing question here, but I suspect the question is either
1) Does JQL have a "group by" clause? To which the answer is "no", because JQL is for finding issues, not displaying the results of the search
2) For internal users, the SQL for groups is simply "have a look at the membership_base table"
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events