Question $4$

$25$ pts

Write an SQL Statement to which employees, their pay, and their shift that worked to "Kitchen Cleaner."

$\backslash$table$[[$PERSON$,,,],[$PersonID$,$LastName,FirstName,PayPerHour,Shift$],[1,$Eagle,Tim,$$12\mathrm{.}00,$Red$],[2,$Smith,John,$$14\mathrm{.}00,$Blue$],[3,$Sorkin,Jim,$$10\mathrm{.}00,$Blue$],[4,$Eagle,John,$$12\mathrm{.}00,$Red$],[5,$Franks,Jim,$$13\mathrm{.}00,$Red$]]$

$\backslash$table$[[$IOB$\_$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]]$

$\backslash$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$]]$

Edit View Insert Format Tools Table

$12$pt $*$ Paragraph

Search