Write 1 procedure or 1 function for each question and test them; please give the correct run screenshot,,,, DO NOT give useless SQL codes.....

5. When client is returning the car (can pass reservation ID or client ID): The reservation ID is given. If a reservation is for more than 10 days, a 10% discount is offered If the reservation in having Christmas day in between, a 20% discount is offered. Now calculate the cost and ask for the payment. If client is not paying, or car is broken by the client, the client is moved to black list table with the reason

6. At the end of every year, the reservation table is emptied out (Leaving the records without end_date), The data is moved to the archieved_reservation

8. Stats are generated and copied to the stats table.