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.
\table[[PERSON,,,],[Personid,Last Name,FirstName,PayPerHour,Shift],[1,Eagle,Tim,$ 12.00,Red],[2,Smith,John,$ 14.00,Blue],[3,Sorkin,Jim,$ 10.00,Blue],[4,Eagle,John,$ 12.00,Red],[5,Franks,Jim,$ 13.00,Red]]
\table[[JOB ASSIGNMENT],[AssignID,PersonID,JobID],[1,2,6],[2,1,1],[3,3,2],[4,1,4],[5,4,6],[6,5,5],[7,5,4],[8,4,3]]
\table[[JOBS,],[JobID,Name,Difficulty],[1,Dishes,Low],[2,Greeter,Medium],[3,Server,Medium],[4,Bus Tables,Low],[5,Kitchen Cleaner,Medium],[6,Shift Manager,High]]
Write an SQL Statement to show which employees

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 Programming Questions!