write pl/sql code with output

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 INSERT INTO employee VALUES ( 110, 'Lauren, 'H''Alexander 749503756, DEFAULT, 5000, 56. INSERT INTO employee VALUES ( 111, als " Les 396012058, DEFAULT, 05000, 57. INSERT INTO employee VALUES ( 112, Dave Hernard 184759364, DEFAULT, 60000 sa TNSERT INTO employee VALUES (113, Steve', L, 18593745, DEFAULT, 55000, 59 INSERT INTO employee VALUES (114) "A", "Horne 117501253, DEFAULT, 45000, 60 - INSERT INTO employee VALUES ( 124, Scott, > Long 912050121, DEFAULT, 3000, 61. INSERT INTO employee VALUES ( 115,0m, 'best' 184629673, DEFAULT, 24000, 62. INSERT INTO employee VALUES ( 126, Sue', A'Donald, 285912756, DEFAULT) 36000 63. INSERT INTO employee VALUES ( 117, Trish', 's', 'Albert 549105738, DEFAULT, 18000, 64. INSERT INTO employee VALUES ( 125, Terry's sell 385937712, DEFAULT, 22000, 65 INSERT INTO employee VALUES ( 119, Dave Nisbet 759127547, DEFAULT, 39809, 66 INSERT INTO employee VALUES ( 120, "Anne', 'M', 'Richie 834577193, DEFAULT, 40000, 67 INSERT INTO employee VALUES ( 122, Jake's "L", "Lee 112954925, DEFAULT 45000, 68. INSERT INTO employee VALUES ( 118, "Janice's 'Harper, 912758396, DEFAULT, 29000, 295213. DECT INSERT INTO amlovee VALTIFS