Q$2$: Write postgresql code

A company record its employees movement In and Out of office in a table with $3$

columns

a$)$ Find number of employees inside the Office at $"2019-05-01$

$19$:$05$:$00"$

b$)$ Measure the amount of hours spent by each employee inside the office between

$"2019-04-0114$:$00$:$00"$ and $"2019-04-0210$:$00$:$00"($Consider all edge cases that are

possible$).$

Table Name:EmployeeRecord

About Table:

Created

$2019-04-0112$:$00$:$00$

$2019-04-0115$:$00$:$00$

$2019-04-0117$:$00$:$00$

$2019-04-0121$:$00$:$00$

First entry for each employee is $"$In$"$

Every $"$In$"$ is succeeded by an "Out"

No data gaps and, employee can work across days