使用COUNT查询SQL时出现问题

Question

列出仅保留红色船只使用计数聚合函数的保留日。这是桌子

仆人桌：

sname rating
Joe 4
Bob 2
Tim 9
Mike 1
Lewis 5

船桌：

bname color rating
Ace orange 6
Bethany red 5
Cruiser green 9
WindySea red 8

预订表：

sname bname day
Bob  Ace Monday
Bob  Bethany Wednesday
Bob  WindySea Saturday
Tim  Ace Sunday
Tim  Bethany Wednesday
Tim  Cruiser Wednesday
Mike Ace Monday

Answer 1

SELECT r.day 
FROM reservation r
JOIN boat b
  ON r.bname = b.bname
GROUP BY r.day 
HAVING COUNT(CASE WHEN b.color <> 'red' THEN 1 ELSE NULL END) = 0
   AND COUNT(CASE WHEN b.color = 'red' THEN 1 ELSE NULL END) > 0 -- optional