SQL advanced SQL

a) Declare a cursor of the room table containing all hotel numbers and hotel names

b) Open the above cursor and use it to generate the hotel numbers and names one by one

c) Release the above cursor

d) Create a stored procedure to update the room prices in hotel Hilton by 6% and in other hotels by 4%.

e) Use the above procedure to update the room prices.