By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE kittens
(id INT, kitten_group INT, kitten_id VARCHAR(255));
INSERT INTO kittens VALUES
(1, 2, '0001'),
(2, 2, '0002'),
(3, 2, '0003'),
(4, 3, '0001'),
(5, 3, '0002'),
(6, 3, '0004'),
(7, 2, '0005'),
(8, 4, '0005'),
(9, 4, '0006');
SELECT kitten_group, COUNT(DISTINCT kitten_id) AS counts FROM kittens
WHERE kitten_id IN (0001, 0002, 0004)
GROUP BY kitten_group
HAVING counts = 3
| kitten_group | counts |
|---|---|
| 3 | 3 |
SELECT kitten_group, COUNT(DISTINCT kitten_id) AS counts FROM kittens
WHERE kitten_id IN (0005, 0006)
GROUP BY kitten_group
HAVING counts = 2
| kitten_group | counts |
|---|---|
| 4 | 2 |