Question: Hands on Exercises The questions below are based on the database that you have created in tutorial 6 (employee.sql). (a) Undate FMP PCT accordino to
Hands on Exercises The questions below are based on the database that you have created in tutorial 6 (employee.sql). (a) Undate FMP PCT accordino to the fioure helow: (b) Using a single command sequence, write the SQL code that will change the project number (PROJ_NUM) to 25 for all employees whose job classification (JOB_CODE) is 502 or higher. (c) Create a temporary table named TEMP_ 1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT. Then copy the EMP_2 values into the TEMP_1 table. (d) Write the SQL command that will delete the newly created TEMP_1 table from the database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
