How to get users who provide all services?

Question

PostgreSQL

There is an array of service id: [1, 3]. You need to get users who provide all services. How to do it? Here is the table schema:

Answer 1

By counting the number of services from this list provided by each user. If there are two of them, then display such a user.