Q1. SQL
Given tables:
employees(id, unixname,team,role,days_since_started)
projects(id,name,....)
commits(id,file_path,proj_id,auth_id,timestamp)
Find the number of unique employees per project per month?
Q2.
Imagine you have a CSV file:
john_doe,android,ios,infra
bob_law,is,backend
jane_doe,frontend
------------------------------
Containing,for each employee, a list of projects he/she works on
Write a script/function/else that reads data from CSV file and creates a data structure that stores, for each project, a list of employees who work on it.