SQL query for filter?

Question

SQL

There is a table of users with the following structure:
id - integer primary key of sequential numbering
username - user login
city_id - user's city of residence It is
necessary to select cities where at least N users live.
Help with this request, thanks!

Answer 1

select city_id, count(id) as kolvo
from table
having count(id)>= 5--N - пользователей