write answers in sql script please PLEASE ONLY SOLVE 13 THROUGH 16 i provided the table so you can use to answer the questions

9. Insert following values into PayRoll table. DO NOT insert employee_num and job_desc, those should be auto populated using auto_increment and default values, respectively.

job_id	pay_date	emp_pay
10	current date	12000.99
11	current date	14000.99
12	current date	16000.99

10. Update emp_pay in PayRoll table for employee_num = 2 with 10% emp_pay increase i.e. (emp_pay * 0.10).

11. Create Project_backup table from project table you created above using bulk insert statement only for last_name 'Smith'.

12. Create VIEW as PayRoll_View from PayRoll table you created above. However, your VIEW should only contain job_id, job_desc and pay_date for job_id > 10.

13. Create Index for pay_date on PayRoll table.

14. Delete all data from project_backup table but keep the table structure.

15. Write a DELETE script to delete a row from Project table where project_num = 10.

If there is an error, give a short explanation of what/why about error msg?

16. Solve the question 15 above without error, i.e. write a script how you can delete.