By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE booking
(`hotelNo` int, `guestNo` int, `dateFrom` datetime, `dateTo` datetime, `roomNo` int)
;
INSERT INTO booking
(`hotelNo`, `guestNo`, `dateFrom`, `dateTo`, `roomNo`)
VALUES
(1, 1, '2022-03-10 00:00:00', '2022-03-17 00:00:00', 1),
(1, 2, '2019-07-01 00:00:00', '2019-07-08 00:00:00', 1),
(4, 3, '2022-03-01 00:00:00', '2022-03-09 00:00:00', 6),
(4, 5, '2022-07-15 00:00:00', '2022-07-25 00:00:00', 7),
(5, 6, '2022-03-20 00:00:00', '2022-03-29 00:00:00', 10),
(5, 7, '1987-03-10 00:00:00', '1987-03-21 00:00:00', 12)
;
select roomNo, max(dateTo) as dateTo
from booking
group by roomNo
having Year(CURRENT_DATE)-2 > year(max(dateTo));
| roomNo | dateTo |
|---|---|
| 12 | 1987-03-21 00:00:00 |