For the maximum number of
reservations:
SELECT TOP 1
Year(StartDate) As [Year],
Count(1) As Reservations
FROM
ReservatonsOfTheMovies res
GROUP BY
Year(StartDate)
ORDER BY
Reservations DESC
;
For the maximum number of
different movies reserved in a year:
SELECT TOP 1
Year(StartDate) As [Year],
Count(DISTINCT IDMovie) As Reservations
FROM
ReservatonsOfTheMovies res
GROUP BY
Year(StartDate)
ORDER BY
Reservations DESC
;