Question: Refer to Additional Query 4. Modify the SQL statement to show the sum of hours worked for service dates 2019-10-08, 2019-11-08, 2019-12-08. Submit the query

Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL
Refer to Additional Query 4. Modify the SQL statement to show the sum of hours worked for service dates 2019-10-08, 2019-11-08, 2019-12-08. Submit the query and select the result from the answers below. Select one: O a 25 .b. 21.75 OC 25.25 Od 28.25 Refer to Additional Query 1. Modify the SQL statement to show the number of times hours worked for a property service is greater than 3 hours. Submit the query and select the result from the answers below. Select one: 24 b. 52 OC 0 d. 28 Answer saved Points out of 1.00 Flag question Refer to Additional Query 3. Which of the following WHERE clauses retrieve the rows with service descriptions that begin with the word 'Trim'? Select one: O a. WHERE Service Description = LIKE 'Trim% b. WHERE Service Description = 'Trim% OC. WHERE Service Description LIKE 'Trim% Od. WHERE Service Description LIKE 'Trim Refer to Additional Query 2. Modify the SQL statement to show the sum of hours worked for the employee id of 1 with service dates after May 5, 2019. Submit the query and select the result from the answers below. Select one: O a. 94 Ob. 32 c. 33 d. 4.50 Refer to Part F. Choose the names of all employees with an experience level of Master and whose FirstName begins with the letter J. Select one: Ma. John Evanston, Jerry Murphy, Joan Fontaine Ob. John Evanston, Jerry Murphy Oc Jerry Murphy Od John Evanston, Joan Fontaine TUUIL-JU Sample Data for Garden Glory OWNER Table Ownert OwnerName OwnerEmailAddress OwnerType Mary Jones Mary Jones somewhere.com Individual 2 DT Enterprises DTE@dte.com Corporation 3 Sam Douglas Sam.Douglas somewhere.com Individual 4 UNY Enterprises UNYE@unye.com Corporation 5 Doug Samuels Doug Samuelssomewhere.com Individual Summary: Structured Query Language B KP Eastlake Office 123 Eastlake Seattle WA 98119 Building 2 2 2 Elm St Apts Apartments 4 East Lynwood WA 98223 1 Elm 3 Jefferson Hill Office Bellevue WA 42 West 7th St 98007 2 Lake View Apts Apartments 1265 Redmond WA 98052 3 32nd Avenue 5 Apartments 65 32nd Redmond WA Kodak Heights Apts 98052 Avenue 6 Jones House 1456 Bellevue WA 98007 Private Residence 48th St 7 1567 Bellevue WA 98007 3 Douglas House Private Residence 51st St 8 Samuels 567 Redmond WA 98052 on 5 Private Residence House 151st St Summary: Structured Query Language Property ServiceID PropertyID ServiceID ServiceDate Employeeld Hours Worked 1 N 2 2019-05-05 1 4.50 2 3 2 2 2019-05-08 3 4.50 3 2 1 2019-05-08 2 2.75 4 6 1 2019-05-10 5 2.50 5 5 5 2019-05-12 4 7.50 6 8 1 2019-05-15 4 2.75 7 4 4 2019-05-19 1 1.00 8 7 1 2019-05-21 2 2.50 9 6 3 2019-06-03 5 2.50 10 5 7 2019-06-08 4 10.50 11 8 3 2019-06-12 4 2.75

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 General Management Questions!