分组查询结果分组

Question

我想知道某个用户在同一天做一次活动的频率

SELECT COUNT(*) FROM Activity
GROUP BY entity_uid, date

这将返回一个很长的计数列表：

1
1
2
1

然后，我想对这个查询的结果进行分组，它告诉我每个数字在结果集中出现的频率，如下所示

#    Count(*)
1    3
2    1

这是我有的，但它不能工作

Select x = (
            SELECT COUNT(*) FROM Activity
            GROUP BY entity_uid, date
           ),
       Count(*)
GROUP BY x

如何在变量中选择子查询的结果？

Answer 1

试试下面的

select daily_user_count, count(*) from (
SELECT COUNT(*) as daily_user_count FROM Activity
GROUP BY entity_uid, date
) Z
group by daily_user_count

Answer 2

试一试

SELECT Frequency, COUNT(*) [Count]
FROM (
    SELECT COUNT(*) Frequency 
    FROM Activity
    GROUP BY entity_uid, date
) t
GROUP BY Frequency