SQL group by - match all items in a given list

I have a table like below:

I want to select group of ids with specific device models given in a list. At first, I tried:

SELECT id
FROM tbl
WHERE device_model IN ('A', 'B')
GROUP BY id

But this works like OR... if an id has only one of ('A', 'B') it is returned. This is not the behavior I want, instead I want AND behavior.

I thought I can use this:

SELECT id
FROM tbl
WHERE device_model IN ('A', 'B')
HAVING COUNT(DISTINCT device_model) = 2;

But, this returns id 1 and 3; but I only want 1, not 3... since it also has device model C.

What can I do to get ids that contain exactly those device models given in a list?

Add the GROUP BY clause and one more condition inside the HAVING clause, that checks the presence of only A,B inside the field device_model.

SELECT id
FROM tbl
GROUP BY id
HAVING COUNT(DISTINCT device_model) = 2
   AND MIN(device_model IN ('A', 'B')) = 1;

This should work on MySQL, and should generalize well on any n amount of elements you want to check. It would suffice to add all your elements inside the array, and update the number of distinct elements.

Output:

Check the demo here.