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.
Assistant Scientist Interview Questions
54,225 assistant scientist interview questions shared by candidates
How many dentist are there in the US?
Given a database of posts and a database of comments on those posts, how do you determine how many conversations are happening in the comments per post on average.
Statistical theory, case question
How to build a dictionary in such a way that it'd be efficient to search for all valid words which are permutations of a given string?
The three data structure questions are: 1. the difference between linked list and array; 2. the difference between stack and queue; 3. describe hash table.
Q. Tell me about a time when you were short on deadline and how did you handle it? Q. Write a Python code to return the count of words in a string Q. What is cross validation Q. Tell me about your favorite algorithm
If you were the one interviewing, what type of person would you look for, for this role?
How would you build and test a metric to compare two user's ranked lists of movie/tv show preferences?
given a table massenger_sends, date | ts | sender_id | receiver_id| message_id | has_reaction Q1) how many unique conversation threads are there ? note that there are threads that sender_id and receiver is inverse. this should be one thread
Viewing 101 - 110 interview questions