30. Employee Absences

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Table of Contents

Contents are not accessible

Problem

Table: Employee

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| employee_id    | int     |
| employee_name  | varchar |
| start_date     | date    |
| end_date       | date    |
+----------------+---------+
employee_id is the primary key for this table.
Each row of this table indicates the employee's name and the start and end dates of their absence period.
It is guaranteed that start_date <= end_date.

Problem Definition

Write a solution to find all employees who were absent for more than three consecutive days.

.....

Like the course? Get enrolled and start learning!

Table of Contents

Contents are not accessible