SQL: each user's first share and closest collaborator
Tables hold users, files and user actions on files. Write SQL that finds the first time each user shared a file, then a query for each user's closest collaborator, the person they share or work on the most files with.
No answer yet. Write the first one; the best answer gets endorsed.
