Homework write SQL Statement

User Generated

f_n989

Programming

Description

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

...............................

Unformatted Attachment Preview

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
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hey am through please find the correct answer in the attached file

Running Head: SQL ASSIGNMENT

1

SQL Assignment
Name

Institution

SQL Assignment

2

Query Number 1
select * from person where shi...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags