Example
SELECT F.NAME, \n" + COUNT(JQL.KEY) `ISSUE COUNT` MIN(JQL.CREATED) `OLDEST ISSUE` MAX(JQL.UPDATED) `MOST RECENT UPDATE` FROM CORE.FILTERS F CROSS JOIN LATERAL TABLE(AUX.JQL('KEY, CREATED, UPDATED', F.QUERY)) JQL GROUP BY F.NAME
SELECT F.NAME, \n" + COUNT(JQL.KEY) `ISSUE COUNT` MIN(JQL.CREATED) `OLDEST ISSUE` MAX(JQL.UPDATED) `MOST RECENT UPDATE` FROM CORE.FILTERS F CROSS JOIN LATERAL TABLE(AUX.JQL('KEY, CREATED, UPDATED', F.QUERY)) JQL GROUP BY F.NAME