I don't think that JQL supports "join" operations. This means that you cannot perform aggregate queries like this one.
However, JQL is not a database query language. For example, JQL does not have a SELECT statement.
https://confluence.atlassian.com/display/JIRA/Advanced+Searching
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.