---

WITH RECURSIVE DateSeries AS (
    SELECT start_date AS day, end_date
    FROM Reservations
    WHERE room_id = 1
    
    UNION ALL
    
    SELECT day + INTERVAL 1 DAY, end_date
    FROM DateSeries
    WHERE day < end_date
)
SELECT DISTINCT day
FROM DateSeries
ORDER BY day ASC;