Nate, would it also work to select user_id, session_type, MIN(session_start) to identify each users first session type instead of using the rank window function?
Can I use (Select User_ID, MIN( session_start) From twitch Where session_type = ' viewer ') As a sub query instead of rank( )????
4 місяці тому
Just found out his video and for sure you can do that in a CTE, I was going. to comment it. I personally think that the solution here is an overkill and that not go that well with the person interviewing you, it shows skill, for sure, but at the cost of over complicating things
Hey Nate, Your videos really helped me learning SQL...Can you make videos on how to use API for data and then saving it in some database as you told in one of your video that it is important part in data science process and it is widely used in professional data scientist projects?
Great video, and your content has been a huge help preparing for my BIE interview. Quick question, let's say there was more than one session created at the same time due to dirty data. My intuition is to use ROW_NUMBER() then to get a single first session no matter what, ordering by another column to break weird ties based on assumptions about which session id tends to be the "right" one when duplicated. Am I in the right ballpark here, or am I thinking about this wrong?
You're on the right track. There's no right answer on how to process dirty data. It's more of an agreement with the interviewer. Once you both agree then start solving the question.
Is there a video with this question solved using CTEs and temp tables? I've just started SQL and for now it's not clear to me when to use subqueries, cte or temp tables. Would love to see the same problem solved in 3 ways. It will help with improving the logic as well
There isn't a video specifically that uses CTEs and temp tables to answer this question. But you can use them for sure to do so. I would go on the platform and try to solve this question using CTEs. To address your last comment, you can use subqueries, ctes, and temp tables interchangeably. It really just depends on the use case and how much data is in our tables that will dictate what you choose.
I haven't found any so far but I do continue to look out for Paypal interview questions. They'll definitely be on the monthly releases if I find any. Thanks for following!
I cant even check solution without premium. Checking solution requires premium. Are you for real guys? If I cant check solution why am i wasting my time.
When i first saw it 6-7 months ago got scared and demotivated to shift job. But recently i started practicing sql basics and now Alhamdulillah this video does not look that hard. It gave me great confidence thanks for great video. And can you share your insta id please
We typically put 4 spaces for indentations. This code was actually copied from a site that helps format code. It looks like code I've seen in industry and follows best practices. Although, I see 1-2 lines that have too much spacing, all the other lines look okay to me. Maybe there's just too many nested parts that could be refactored into CTEs?
![Most Common Data Science SQL Interview Question from DoorDash [window functions & partitions]](http://i.ytimg.com/vi/T1UhSuKqy3A/mqdefault.jpg)
![Solving Complex SQL Interview Questions [How to organize lengthy code solutions]](/img/n.gif)
Hey, I am digging your videos! I love the focus on particular companies SQL questions.
Thanks so much man! I also got your message on Mediu and emailed you. But if you don't get my email feel free to reach out at nate@stratascratch.com
@@stratascratch Awesome!
Thank you Nate! And love your content and love your web site!
Glad you enjoy it!
Nate, thank you for these videos. Extremely helpful.
You are awsome sir....Keep posting such a great sql videos....
Thank you so much for your videos. I learned a lot 👍🏻👍🏻👍🏻
Thanks for putting out all of this great content.
Thanks for watching the videos! More to come
Thanks Nate! As always very clear explanation.
Thanks! Always appreciate your comments on my videos!
Nate, would it also work to select user_id, session_type, MIN(session_start) to identify each users first session type instead of using the rank window function?
Yes it would work but rank() is more appropriate and more explicit.
Thank you Nate
Can I use
(Select User_ID, MIN( session_start)
From twitch
Where session_type = ' viewer ')
As a sub query instead of rank( )????
Just found out his video and for sure you can do that in a CTE, I was going. to comment it. I personally think that the solution here is an overkill and that not go that well with the person interviewing you, it shows skill, for sure, but at the cost of over complicating things
Hey Nate, Your videos really helped me learning SQL...Can you make videos on how to use API for data and then saving it in some database as you told in one of your video that it is important part in data science process and it is widely used in professional data scientist projects?
Yup! That's coming out soon. It's taking a while to create it ... sorry!
hope that i can get any technical interview test soon so that i can apply what i learn from you :)
I think this video will certainly help! Good luck
Thank you!
Great video!
Thanks for watching!
Great video, and your content has been a huge help preparing for my BIE interview.
Quick question, let's say there was more than one session created at the same time due to dirty data. My intuition is to use ROW_NUMBER() then to get a single first session no matter what, ordering by another column to break weird ties based on assumptions about which session id tends to be the "right" one when duplicated. Am I in the right ballpark here, or am I thinking about this wrong?
You're on the right track. There's no right answer on how to process dirty data. It's more of an agreement with the interviewer. Once you both agree then start solving the question.
Is there a video with this question solved using CTEs and temp tables? I've just started SQL and for now it's not clear to me when to use subqueries, cte or temp tables. Would love to see the same problem solved in 3 ways. It will help with improving the logic as well
There isn't a video specifically that uses CTEs and temp tables to answer this question. But you can use them for sure to do so. I would go on the platform and try to solve this question using CTEs. To address your last comment, you can use subqueries, ctes, and temp tables interchangeably. It really just depends on the use case and how much data is in our tables that will dictate what you choose.
👌👌👍
Great!
Thanks man =)
Will there be a collection of SQL and Python questions asked in PayPal?
I haven't found any so far but I do continue to look out for Paypal interview questions. They'll definitely be on the monthly releases if I find any. Thanks for following!
thanks
I cant even check solution without premium. Checking solution requires premium. Are you for real guys? If I cant check solution why am i wasting my time.
Why not just run the code and manually check the output?
@@stratascratch That wont check for edge cases.
When i first saw it 6-7 months ago got scared and demotivated to shift job. But recently i started practicing sql basics and now Alhamdulillah this video does not look that hard. It gave me great confidence thanks for great video. And can you share your insta id please
this coding format is so hard to read, don't just some how indent the line as you feel like it, looks terrible guys
We typically put 4 spaces for indentations. This code was actually copied from a site that helps format code. It looks like code I've seen in industry and follows best practices. Although, I see 1-2 lines that have too much spacing, all the other lines look okay to me. Maybe there's just too many nested parts that could be refactored into CTEs?