Take care when counting multi-assign terms to ensure you capture all assignments.
RETURN TermCounts AS SELECT COUNTDISTINCT(Term) as NumTerms, /* wrong; term is de-multi-assigned * prior to COUNTDISTINCT */ COUNT(Term) as NumAssignments GROUP BY Category
DEFINE Terms AS SELECT COUNT(1) AS Assignments GROUP BY Term, Category ; RETURN TermCounts AS SELECT COUNTDISTINCT(Term) as NumTerms, SUM(Assignments) AS NumAssignments FROM Terms GROUP BY Category