Tutorial 7 Employee Job Job code Job name 500 Manager 501 Programmer 502 Data Scientist Anne EMP_NUM EMP_LNAME EMP_FNAME EMP_INITIAL EMP_HREDATE JOB_CODE 01 News John G 08-Nov-00 502 102 Senior David H 12-Jul-89 501 103 Arbough June E 01-Dec-96 500 104 Romoras K 15-Nov-87 501 105 Johnson Alice K 01-Feb-93 502 106 Smithfield William 22-Jun-04 500 107 Alonzo Maria D 10-Oct-93 500 108 Washington Ralph 22-Aug-91 501 109 Smith Larry w 18-Jul-97 501 Write SQL code to (1) Create the above table (ii) Enter the data into the table. ( for the data refer the above table). (iii) Change the job code to 501 for the person whose employee number is 107. (iv) Using a single command sequence write the SQL code to change the project number to 25 for all employees whose job code is 502 or higher (v) Delete the row for the person named William Smithfield, who was hired on June 22, 2004 and whose job code classification is 500 (vi) Display all employee names and their hired date ordered by employee's first name. (vii) Display all employee names, job code and their hired date group by employee's job code. Page 1 / 1 +