TS8uweQM

1drop table if exists users;
2
3create table users(userid int not null);
4
5insert into users values (1),(2),(3),(4),(4),(4),(2),(1),(1),(10);
6
7select
8 u.userid,
9 count(*) as counter
10from
11 users u
12group by
13 u.userid
14having counter > 2
15order by
16 counter desc;
17 
18/*
19
20results:
21
22userid counter
23---------------
24  1	  3
25  4 	  3
26
27
28*/