Question: Write an SQL Statement to show which employees and their specific job that were assigned medium and low difficulty jobs. table [ [ PERSON
Write an SQL Statement to show which employees and their specific job that were assigned "medium" and "low" difficulty jobs.
tablePERSONPersonidLast Name,FirstName,PayPerHour,ShiftEagle,Tim,$ RedSmith,John,$ BlueSorkin,Jim,$ BlueEagle,John,$ RedFranks,Jim,$ Red
tableJOB ASSIGNMENTAssignIDPersonID,JobID
tableJOBSJobIDName,DifficultyDishes,LowGreeter,MediumServer,MediumBus Tables,LowKitchen Cleaner,MediumShift Manager,High
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
