19. Employee Collaboration Networks (Medium)

Grokking SQL for Tech Interviews

Ask Author

Back to course home

0% completed

Table of Contents

Contents are not accessible

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!

Table of Contents

Contents are not accessible