How to make a SQL fetch?

Question

PostgreSQL

Hello. The comments
table has a task_id numeric field that stores non-unique entries. You need to make a unique selection of all task_id entries that have the same value less than 3 . Example: if the task_id contains such entries (1, 1, 2, 3, 3, 3, 4, 5, 5, 5, 5), then you need to get (1, 2, 4) the values ​​3 and 5 are not included, because entries 3 and 5 are greater than three. I tried to solve it like this, but it's definitely wrong. because it returns an empty tuple

SELECT task_id FROM comments GROUP BY task_id HAVING COUNT(task_id)<=3

Can you please tell me how to build a SQL construct?

Answer 1

SELECT task_id, COUNT(task_id) as ct FROM comments GROUP BY task_id HAVING ct<=3