MySQL-查找一个不同的值，但仅当它对某些变量为true时

Question

所以我有下面的表closing_days:

kdv_id<1>

id	名称	日期
1	foo	2021-02-16
2		bar	2021-02-16	2
3	baz	2021-02-16	3
4	qux	2021-02-17	3

您想要带有HAVING子句的GROUP BY：

SELECT date
FROM closing_day
WHERE kdv_id IN (x, y, z) AND
datum >= '2021-02-15' AND
datum <= '2021-02-19'
GROUP BY date
HAVING COUNT(DISTINCT kdv_id) = 3  -- number of items in `IN` list