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 22:00
Your task this week is to write a very simple spam classifier in python. it will classify messages as either spam (unwanted) or ham (wanted). the program will have a set of spam_words, words that are known to appear in spam messages. that set is included in the template file spam.pypreview the document. you will also define a spam threshold which reflects the allowed percentage of spam words in the message. you'll compute a 'spam indicator', which is the ratio of spam words to the total number of unique words in the message. if the spam indicator exceeds the spam threshold, the message is classified as spam. otherwise it is classified as ham. we'll assume that the spam threshold is a constant and has a value of 0.10. your program will prompt the user for a message and then will print the corresponding spam indicator with two decimal digits and the corresponding classification (spam or ham). the program will be case insensitive. the spam words are detected whether they are in lower case or upper case or mixed case. each word, spam or not, is counted once (even if it appears multiple times in the message.) the program will remove punctuation from the message before identifying the words and computing the spam indicator. for example '! ' must be identified as the spam word 'now'.
Answers: 3
question
Computers and Technology, 22.06.2019 19:00
Which parts of a presentation should be the most general? a. introduction and conclusion b. introduction and outline c. outline and conclusion d. outline and body
Answers: 1
question
Computers and Technology, 22.06.2019 23:30
In my email i got a message it says a quick message and in message details on who its from its says nicole and under nicole is [email protected] -
Answers: 1
question
Computers and Technology, 23.06.2019 19:30
Amitha writes up a one-page summary of a novel during her summer internship at a publishing company. when she reads over the page, she realizes she used the word β€œforeshadow” seven times, and she would like to reduce the repetition. which tool would best amitha solve this problem?
Answers: 3
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
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
question
Mathematics, 19.11.2020 01:10
Questions on the website: 13722361