SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE HotelAccommodation (
    Id INT IDENTITY(1,1),
    HotelCode VARCHAR(50),
    AccomodationPeriodBegin DATE,
    AccomodationPeriodEnd DATE,
    RoomType VARCHAR(10),
    AccmdMenTypeCode VARCHAR(10),
    Price INT,
    OverlapDaysCount INT
);

Declare
  @accomodationDateFrom DATETIME	= '2025-01-15',
  @accomodationDateTo DATETIME		= '2025-05-07'
declare
  @NeededDaysCount as int = DATEDIFF(DAY, @accomodationDateFrom, @accomodationDateTo) + 1
  
INSERT INTO HotelAccommodation (HotelCode, AccomodationPeriodBegin, AccomodationPeriodEnd, RoomType, AccmdMenTypeCode, Price, OverlapDaysCount)
VALUES
('MONTE', '2025-01-15', '2025-02-28', 'DGV', '01010312', 99, 45),
('MONTE', '2025-01-15', '2025-02-28', 'DGV', '01010003', 99, 45),
('MONTE', '2025-03-01', '2025-03-10', 'DGV', '01010003', 106, 10),
('MONTE', '2025-03-01', '2025-03-10', 'DGV', '01010312', 106, 10),
('MONTE', '2024-03-11', '2025-05-07', 'DGV', '01010312', 109, 58),
('MONTE', '2024-03-11', '2025-05-07', 'DGV', '01010003', 90, 58),
('MONTE', '2024-03-11', '2025-05-07', 'DGV', '01010510', 111, 113),
('MONTE', '2024-03-11', '2025-05-07', 'DGV', '01010515', 222, 113),
('MONTE', '2024-03-11', '2025-05-07', 'DGV', '01010615', 222, 112),
('MONTE', '2024-03-11', '2025-05-07', 'DGV', '01010616', 222, 114);

select 
    HotelCode, RoomType, AccmdMenTypeCode 
	,SUM(OverlapDaysCount) as TotalDays
	,SUM(OverlapDaysCount * Price) AS TotalPrice
FROM HotelAccommodation
GROUP BY HotelCode, RoomType, AccmdMenTypeCode
HAVING SUM(OverlapDaysCount) = DATEDIFF(DAY, @accomodationDateFrom, @accomodationDateTo) + 1 
ORDER BY TotalPrice, HotelCode, AccmdMenTypeCode ;

HotelCode	RoomType	AccmdMenTypeCode	TotalDays	TotalPrice
MONTE	DGV	01010003	113	10735
MONTE	DGV	01010312	113	11837
MONTE	DGV	01010510	113	12543
MONTE	DGV	01010515	113	25086