Computers and Technology, 01.09.2020 22:01 clairee002

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

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 19:00, devila321

When keyboarding, if you want to be fast and accurate you should return your hands on home row with your fingers relaxed and your eyes on the text use only your index fingers to hunt and peck keep your fingers stiff and your eyes on the keys slouch in your chair and keep your fingers hovering over all of the keys

Answers: 2

continue

Computers and Technology, 22.06.2019 18:30, smariedegray

All of the following are characteristics that must be contained in any knowledge representation scheme except

Answers: 3

continue

Computers and Technology, 23.06.2019 00:20, kathlynskare06

Ihave been given the number of guns per 100, and the total firearm-related deaths per 100,000. i have to find the actual number of guns per country and actual number of gun-related deaths. if somebody could show me how to do 1 question, i can finish the rest, i am just confused. tia

Answers: 3

continue

Computers and Technology, 23.06.2019 01:30, winstonbendariovvygn

1. which of the following is a search engine? a) mozilla firefox b)internet explorer c)google d)safari 2. which of the following statements is true? a) all search engines will provide the same results when you enter the same query. b) all search engines use the same amount of advertisements. c) some search engines are also browsers. d) search engines often provide different results, even when you enter the same query.

Answers: 2

continue

You know the right answer?

A business uses a time clock to track how many hours an employee works per day. Employees are instru...