Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
19. Employee Collaboration Networks (Medium)

Problem Statement

Table: CollaborationAccepted
Each row in this table records an instance where one employee invites another to collaborate on a project, and the invitation is accepted.

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| inviter_id     | int     |
| invitee_id     | int     |
| project_id     | int     |
| accept_date    | date    |
+----------------+---------+
The combination of (inviter_id, invitee_id, project_id) is the primary key for this table.

.....

.....

.....

Like the course? Get enrolled and start learning!