A SQL query to display the details of the customers (customer id, customer name, rental id) who took the maximum number of rentals of that particular year

select max(rentalcount) into @maxrental from (select count(*) as rentalcount from rentals where year(rent_srt_date)=Yeartofind group by customerid) as rentaltable;
select customerid,customer_name,rental_id from 
(select customerid,customer_name,rental_id,count(*) as rentalscount from customers inner join rentals on customers.customerid=rentals.customerid where year(rent_srt_date)=Yeartofind group by customers.customerid order by rentalcount desc) as rentalsgroup 
where rentalscount=@maxrental;

CREATE PROCEDURE `TopRental` (
vYear integer)
BEGIN
declare vMaximun integer default 0;
select max(rentalcount) into vMaximun from (select count(*) as rentalcount from rentals where year(rent_srt_date)=vYear group by customerid) as rentaltable;
select customerid,customer_name,rental_id from 
(select customerid,customer_name,rental_id,count(*) as rentalscount from customers inner join rentals on customers.customerid=rentals.customerid where year(rent_srt_date)=vYear group by customers.customerid order by rentalcount desc) as rentalsgroup where rentalscount=vMaximun;

END

Call TopRental(2020);