Load the the Staff table that has been made available for you. You will use a subselect to produce three new tables based on the staff table job. All the managers in MANAGERS, all the clerks in CLERKS and all the sales staff in SALES. (1 mark)
Use the MANAGERS, CLERKS and SALES tables to produce the following output. Do not refer to the STAFF table.
Query the STAFF and MANAGER tables to produce this result without directly referring to the Mgr job.
Query the STAFF and SALES tables to produce this result without directly referring to the Sales job. Note this is in JOB order) (2 marks)
Show a count of how many STAFF and CLERKS rows are identical. (2 marks)
Show all the identical rows of STAFF and CLERKS but do not include any row with a a null value in years. (1 mark)