Create procedure with input parameter and cursor in SQL

Question

SQL

You need to create a procedure with an input parameter and a cursor that displays the following report when you enter a year.

Answer 1

answer.mail.ru/edu_homework

Answer 2

In your last question, I gave you an example of a sql procedure with input parameters. It needs to be improved a little. You should at least try to use your brains a little. And so for you here they will not solve homework. UPD: (for free)