Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

22. Employee Attendance Record
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible