Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
34. Employee Task Tracking (Easy)
On this page

Problem Statement

Table: TaskLog
Each row in this table logs a task completion by an assignee, indicating the task's ID, the employee who assigned the task, the assignee, and the completion date.

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| task_id        | int     |
| employee_id    | int     |
| assignee_id    | int     |
| completion_date| date    |
+----------------+---------+
This table does not have a primary key and may contain duplicate rows.
task_id is the unique identifier for each task.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page