Answered step by step
Verified Expert Solution
Link Copied!

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:

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions