Homework write SQL Statement

See the question in upload files and write SQL statement in word document , p

………………………….

Write a SQL statement to show
which people work the red shift.
PERSON
PersonlD LastName 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
JOB_ASSIGNMENT
AssignID Personld JobID
1
2
6
2
1
1
3
3
2
4
1
4
5
4
6
5
6
5
7
4
5
4
8
3
JobID
1
2
JOBS
Name
Difficulty
Dishes
Low
Greeter
Medium
Server
Medium
Bus Tables Low
Kitchen Cleaner Medium
Shift Manager High
3
4
5
6
Write an SQL Statement to show
which employees and their specific
job that were assigned “medium”
difficulty jobs.
PERSON
Personli LastName 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
JOB_ASSIGNMENT
AssignID PersonlD 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
JobID
1
2
JOBS
Name
Difficulty
Dishes
Low
Greeter Medium
Server
Medium
Bus Tables Low
Kitchen Cleaner Medium
Shift Manager High
3
4
5
6
What does the following SQL
Statement do:
SELECT AVG(PayPerHour)
FROM PERSON
WHERE FirstName Like ‘J%’
Reminder % in SQL is the same as * in Access.
PERSON
PersonlD LastName 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
JOB_ASSIGNMENT
AssignlD PersonlD 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
JobID
1
2
3
JOBS
Name
Difficulty
Dishes
Low
Greeter
Medium
Server
Medium
Bus Tables Low
Kitchen Cleaner Medium
Shift Manager High
4
5
6
Question 4
25 pts
Write an SQL Statement to which
employees, their pay, and their shift
that worked to “Bus Tables.”
JOB_ASSIGNMENT
AssignlD PersonlD JobID
1
2
6
PERSON
PersonlD LastName FirstNamePayPerHour 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
2
1
1
3
3
2
4
1
4
5
4
6
6
5
5
7
5
4
8
4
3
JobID
1
2
3
JOBS
Name
Difficulty
Dishes
Low
Greeter Medium
Server
Medium
Bus Tables Low
Kitchen Cleaner Medium
Shift Manager High
4
5
6