Group results of grouped query

I'd like to know how often a particular user does an activity on the same day

<!-- language: lang-sql -->

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

This returns a long lists of counts: i.e.

1
1
2
1

I'd then like to group the results of this query that tell me how often each number appears within the result set, like this

#    Count(*)
1    3
2    1

Here's what I have, but it doesn't work

<!-- language: lang-sql -->

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

How can I select the results of a subquery in a variable?

Try the below

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