DECLARE @Today date = GETDATE();
SELECT Count(DISTINCT IDMovie)
FROM ReservationsOfMovie
WHERE @Today Between StartDate And EndDate;
SELECT Count(*)
FROM Movies As m
WHERE Not Exists
(
SELECT 1
FROM ReservationsOfMovie As r
WHERE r.IDMovie = m.IDMovie
And @Today Between r.StartDate And r.EndDate
);