Execute the following to build the 'yourfirstname$\_$new$\_$emps' table.

A$.$ Drop the existing table $($if it exists$)$:

DROP TABLE yourfirstname$\_$emps;

B$.$ Create the new table and add additional column:

CREATE TABLE yourfirstname$\_$new$\_$emps AS SELECT $*$ FROM employees;

ALTER TABLE yourfirstname$\_$new$\_$emps ADD stars VARCHAR$2(50)$;

C$.$ Create a PL$/$SQL block to insert asterisks into the 'stars' column based on the

employee's salary. Each asterisk represents $$1,000$ of salary. For example, a salary of

$$7,800$ should result in ${?}^{********},$ and a salary of $$3,100$ should result in ${?}^{****n}.$ Use the

following code as a starting point and complete the 'FOR LOOP' section.

Note that the 'TRUNC$()\text{'}$ removes the decimal portion after dividing the salary by $1,000.$

E$.$g$.,$ for a salary of $$7,800,$ it becomes $7.$

DECLARE

v$\_$empno yourfirstname$\_$new$\_$emps.employee$\_$id$\%$TYPE :$=$