SELECT r.id 
FROM room AS r
INNER JOIN daily_room_status AS drs
ON r.id = drs.room_id
INNER JOIN room_category AS rc
ON r.category_id = rc.id
WHERE rc.category = ?
           AND r.size = ?
           AND drs.status_id IN (SELECT id FROM room_status WHERE STATUS IN ('CUSTOMER'))
           AND (drs.date BETWEEN ? AND ?) 
GROUP BY r.id
HAVING COUNT(r.id) = (TO_DAYS (?) - TO_DAYS(?))

UPDATE daily_room_status 
SET status_id = (SELECT id FROM room_status WHERE STATUS = ?)
WHERE room_id = ? AND (DATE BETWEEN ? AND ?)