複数割当て用語をカウントするときは、すべての割当てを捕捉するように注意が必要です。
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