Health & Wellness
Yesterday
2716
I hate my f***** life
Health & Wellness
Yesterday
2060
I wish I had known earlier
Tech Industry
10h
1557
How can my idiot brother who does real estate afford this
Tech Industry
11h
2158
Are tech workers as rich as they think we are?
Tech Industry
5h
379
Where should we work after TikTok ban?
I have a 1.25 hour interview for a data scientist role at Shopify. This SQL screen is much longer than any other SQL screen I’ve had before so I’m curious what types of questions to expect. Yoe: 8 Tc: $0.00 #data #dataanalytics #datascience #datascientist #shopify #interview #sql #sqlinterview
Prepare for Analytical functions , recursive queries, CTEs and other common SQL questions
Recursive queries?? Seriously? I have never seen anyone ask this in any of the data interviews... Is this just a generalized statement or do they actually ask recursive queries in Shopify interview??
It's an answer to a general question and to make a point that they can't ask beyond those. I also think recursive queries are easier than analytical or windowing function queries.
Order of ops, window functions, difference between dense rank, rank and row number etc…..
Op: what's you current role and TC; YOE?
Sorry. Added. 8yoe 0tc
I was asked python questions
What’s was the team/focus?
Stratascratch and data lemur have some Shopify questions. Also, leet code just added in beta pandas for their sql questions.
All sql questions to advance levels like windows, percentage