2.ÿÿÿÿ Create a new table called JOBS that has the same column names and data types as the EMPLOYEES table.Hint: use CREATE TABLE and the output from the previous step.3.ÿÿÿÿ Show all of the columns in the JOBS table. Hint: use the DESCRIBE command.4.ÿÿÿÿ Insert a copy of all rows from the EMPLOYEES table into the JOBS table.Hint: Use INSERT INTO …. SELECT * FROM …..5.ÿÿÿÿ Insert a new row in the JOBS table and populate all columns. Make up any data you want but populate the FIRSTNAME and LASTNAME columns with your first name and last name and be sure your manager is Paul Stafford. Hint: To find the MANAGERID, look for Paul Stafford EMPLOYEEID.6.ÿÿÿÿ Update the JOBS table by giving a 15% raise to all employees whose manager is Paul Stafford. DO NOT use the manager’s name to do the update – use only the MANAGERID column in the WHERE clause for the update. Hints: Use UPDATE …….;Use WHERE MANAGERID = …;To find the MANAGERID, look for Paul Stafford EMPLOYEEID;a 15% raise is salary X 1.1.7.ÿÿÿÿ The company has outsourced the Information Technology department and fired all workers with a JOBID of ITPROG except for the department manager. Remove those employees from the JOBS table. Use only the MANAGERID column in the WHERE clause. Do NOT use JOBID in the WHERE clause.Hint: use DELETE FROM …. WHERE MANAGERID = ……8.ÿÿÿÿ Show the EMPLOYEEID, FIRSTNAME, LASTNAME, JOBID, MANAGERID, DEPARTMENTID for the manager of the Information Technology department who did not get fired.Hint: use SELECT ….. FROM ……. WHERE …….
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]