Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
22. Employee Attendance Record
On this page

Problem

Table: Employees

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| employee_id   | int     |
| employee_name | varchar |
+---------------+---------+
employee_id is the primary key for this table.
Each row of this table contains the ID and the name of one employee in the company.

Table: Attendance

+---------------+---------+------+
| Column Name   | Type    | Note |
+---------------+---------+------+
| employee_id   | int     |      |
| attendance_date | date  |      |
| status        | varchar |      |

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page