Question: 7. UNION: The weird request in Question 1 now makes sense to you. There is a lawsuit pending which is accusing your company of being

7. UNION: The weird request in Question 1 now
7. UNION: The weird request in Question 1 now makes sense to you. There is a lawsuit pending which is accusing your company of being discriminant on non-performance criteria for promotions. The court has issued a subpoena for records on all current jobs being held, and job changes that have occurred. Take special note in the provided output (rows 34 - 60) that: . Previous positions held by anyone is in the Job_History table. This table does not have the person's current position, only changes. The current position for all employees is in the Employees table. o You will need to use a union here. . There is no start_date and end_date for the currently held position, which is why those show up as NULL in the final results. o You can use literals in place of columns. The only condition is that you are able to combine two queries that have the same number of 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!