subject

A business uses a time clock to track how many hours an employee works per day. Employees are instructed to clock in once when they arrive, and clock out once when they leave. Each event adds a record to the following table: Design a SQL query(s) to find the total amount of hours a certain user worked per day in a given date range. Your resulting query should generate an output similar to the following: DAY USER HOURS CLOCK_EVENTS TIMESTAMP
USER_ID
2018-03-09 ABC
8.13 2018-03-09 08:06:00.740 ABC
2018-03-09 08:06:06.907 ABC
2018-03-09 08:07:18.863
DEF 2016-03-09 08:08:17.853
GHI 2018-03-09 16:19:25.930
ABC 2018-03-09 16:19:42.470
DEF 2018-03-09 16:24:50.930
GHI 2018-03-10 08:02:00.740
ABC 2018-03-10 08:03:18.863
DEF 2016-03-10 08:07:10.853
GHI 2018-02-10 16.05.25920 ARC

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 21:00
You should hand write your references on your resume.
Answers: 1
question
Computers and Technology, 22.06.2019 09:00
Howard is designing a chair swing ride. the swing ropes are 5 meters long, and in full swing they tilt in an angle of 29° outside chairs to be 2.75 m above the ground in full swing.
Answers: 1
question
Computers and Technology, 22.06.2019 10:50
A911 dispatcher is the sole sender of messages to all police officers. while on patrol, officers communicate with the dispatcher who, in turn, relays messages to other officers. the officers do not communicate directly with one another. this illustrates a network.
Answers: 1
question
Computers and Technology, 24.06.2019 12:00
Which spreadsheet operation does a look function perform?
Answers: 1
You know the right answer?
A business uses a time clock to track how many hours an employee works per day. Employees are instru...
Questions
question
Chemistry, 08.12.2020 01:00
question
Mathematics, 08.12.2020 01:00
Questions on the website: 13722367