Use the schema SH from SQL Live

Use the table SH.promotions.

Create a copy of the table SH.promotions

Create a new table to populate the cost of promotion for all promotion category (Promo_category). The table should also show the number of promotion that has been advertise using the associated promotion_category.

Display the content of your new table.

The company has decided to reduce the amount of promotion for every category by 20%. Update the table you created and do the following:

a)Add a column call ads_budget

b)Use cursor variable to calculate the amount of the ads_budget for each promotion category and update the table accordingly.

c)You can also do task (b) above without using cursor variable. Add another column called ads_budget2, and update the column accordingly (this time without using cursor variable)