Write DML statements to accomplish the following:

a$)$ Insert the following records into the Staff table given the following data:

b$)$ Change the following records given the following data:

a$.$ Increase the DiscountPercentage of the Reward that has a RewardDescription

of "Exclusive" by $2.(2$ marks$)$

b$.$ The sales department is getting a raise! Increase the wage of all the sales staff

by $15\%.(3$ marks$)$

c$.$ Remove all the StaffTypes that have no Staff. $(2$ marks$)$

APPENDIX

Customer

Reward

ConsignmentDetails

Training

ConsignmentDetails

Category

Staff

StaffType