give code for PL/sql

1. create a copy of the table employee (New table name is employee_copy) 2. Write anonymous block to display Firstname and Salary of employee number 110 (use %TYPE) 3.Write anonymous block to display average salary of all employees (use %TYPE) 4.What is the difference between %ROWTYPE and %TYPE? 56 55 0 56. 57. 58. 59. 60. 61. 62. 63 64. 65. INSERT INTO employee VALUES ( 110, 'Lauren', 'M', 'Alexander 74003756, DEFAULT, 45000, INSERT INTO employee VALUES ( 111, La "L 396012053) DEFAULT, 05000, INSERT INTO employee VALUES ( 112, Dave Ternard 184759364, DEFAULT60000 INSERT INTO employee VALUES (113, 'Steve', 18593745, DEFAULT, 55000, INSERT INTO employee VALUES (114) 'A', "Horne 1847581253) DEFAULT 45000, INSERT INTO employee VALUES (134, 'Scott, Long 912050121, DEFAULT, 3500, INSERT INTO employee VALUES ( 115,im, Best', 184629673, DEFAULT, 2400 INSERT INTO employee VALUES ( 126, Sue AHDonald', 285912756, DEFAULT, 36000 INSERT INTO employee VALUES (117, Trish', 'S', 'Albert 549105733, DEFAULT, 18000, INSERT INTO employee VALUES ( 125, Terny, 3, Havel 385937712, DEFAULT, 22000, INSERT INTO employee VALUES ( 119, Dave Nisbet, 759127547, DEFAULT, 39000, INSERT INTO employee VALUES ( 120, "Anne', 'M', 'Richies 834577193, DEFAULT, 40000, INSERT INTO employee VALUES ( 122, Jake', L', 'Lee 112954925, DEFAULT, 4500, INSERT INTO employee VALUES ( 118, "Janice, *Harper's 912758396, DEFAULT, 29000, METARA 2952. FEBT TNSERT INTO amlovee VALUES 12.nd. 66 67. 68