Algorithm · Figma · Medium
Examples Example 1 Example 2 Requirements You have three tables that track users, files, and actions. A share or view is recorded when someone other than the file's creator opens the file. SQL For every user, find the moment they first shared a design they created with another person — that is, the earliest timestamp at which a different user viewed one of their files. Design a "closest collaborator" model between users based on who a creator tends to share with first.…
Checking your access…