Facebook Data Scientist | November 2020
?
•Anonymous••Upvote
1
Downvote
Company: Facebook
Position: Data Scientist
Location: nan
Level: nan
Outcome: NA
How was the interview process? What was it like?
Product Based Questions
What technical questions were asked?
nan
What was one of your solutions?
WITH first_time AS (
SELECT caller_id, MIN(date) AS date_used
FROM users
GROUP BY caller_id
SELECT users.caller_id, first_time.date_used AS first_time_used, users.date AS usage_date, users.date - first_time.date_used AS days_between, DATEDIFF('day', users.date, first_time.date_used) AS days_between
FROM first_time
LEFT JOIN users
ON first_time.caller_id = users.caller_id
AND first_time.date_used < users.date
WHERE first_time.date_used = '2019-03-01' AND days_between = X
Facebook
Data Scientist
There's so much more to Interview Query
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.
Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est
quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est