按组分组的最大COUNT数以及在EQUALS和NOT EQUALS条件下的连接

I am working on a scenario where I need to get counts grouped by UserID and then obtain the maximum count obtained from the result set of the grouping.I am working on a scenario where I need to get