Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A company record its employee's movement In and Out of the office on a table with 3 columns (Employee id, Action (In/Out), Created) There is
A company record its employee's movement In and Out of the office on a table with 3 columns
(Employee id, Action (In/Out), Created)
There is NO sample data for this question. You only need to submit the queries
Employee id | Action | Created |
1 | In | 2019-04-01 12:00:00 |
1 | Out | 2019-04-01 15:00:00 |
1 | In | 2019-04-01 17:00:00 |
1 | Out | 2019-04-01 21:00:00 |
- The first entry for each employee is In
- Every In is succeeded by an Out
- No data gaps and, the employee can work across days
Question:
-
Find the number of employees inside the Office at 2019-05-01 19:05:00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started