Facebook Data Scientist | November 2020

?
AnonymousApril 5, 2021, 01:12 AM
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
I
Ichimoku
Top comment
Lorem ipsum dolor sit amet, consectetur adipiscing elit
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.
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

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
I
Ichimoku
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium 😀
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

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

Related posts

Amazon Manager Business Intelligence Manager | June 2021
UBS Senior Quantitative Analyst | April 2021
Bristol Myers Squibb Senior Research Scientist | March 2021
Amazon Entry Level Cloud Support Engineer Analytics | August 2022
There's so much more to Interview Query! Sign up to access hundreds of interview questions, expert coaching and a flourishing data science community.