GeometricMean

Returns the geometric mean of the values in each group: the nth root of their product. Useful for growth rates and ratios.

Numeric GeometricMean(AggregationArray valuesArray)

Groups the synonyms by source word and computes GeometricMean of the target word ids.

SELECT
    SourceWordId,
    GeometricMean(TargetWordId) as Result
FROM
    WordList:Synonym
GROUP BY
    SourceWordId

• Group By
• Aggregate Functions