Write a SQL statement to create a table mydoctor that has the following columns and rules.

Write a sql script that can be used to insert into mydoctors table by prompting the user to do so. (Substitution variables)

Insert the following rows into mydoctor table. (Do not use substitution variables)

Add another doctor into the mydoctor table. This doctor does not have his pay set yet. The doctor is Mrs. Van Wissel and the id is 96385.

Remove all the doctors who are currently paid from the mydoctor table.

Remove from the table all the doctor(s) left.

Remove mydoctor table from the database.

Tooma 10194 16.29 DSO23AT.tok6034b85d0dba6.docx Saved on device a. Write a SQL statement to create a table mydoctor that has the following columns and rules. (5) Column Doctor_identity Doctor_name Data type & size Must be 5 characters Must be at most 15 characters Must be numeric Doctor_pay b. Write a sql script that can be used to insert into mydoctor's table by 14586 54612 17896 ZuluSiphamandla Ndlovu Nomphilo Johnson Johnson 14000 15260 11520