Glassdoor Data Scientist | March 2021
?
•Anonymous••Upvote
1
Downvote
Company: Glassdoor
Position: Data Scientist
Location: nan
Level: nan
Outcome: NA
How was the interview process? What was it like?
An internal stakeholder comes to you and says that, according to her report, application submissions are down. What do you do to investigate?
What technical questions were asked?
nan
What was one of your solutions?
SELECT month_dt, (unregistered*1.0 / all_clicks) as percentage
FROM(
SELECT month_dt, count(distinct(click_id)) as all_clicks,
sum(
CASE WHEN user_id is null THEN 1
ELSE 0 END
) as unregistered
FROM clicks
GROUP BY 1
) t
Glassdoor
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