如何使用SQL Server中的随机聚合函数进行分组?

I have the following SQL:

我有以下SQL:

select Username, 
    COUNT(DISTINCT Message) as "Count", 
    AVG(WordCount) as "Average",
    RAND(Message) //Essentially what I want to do 
from Messages
group by Username
order by "Count" desc
select U