Thanks for watching. Interval is used to shift a timeframe based on the interview you choose. So now()-interval '1 month' will shift the date 1 month in the past from today's date.
Yes, some have been deleted as the questions on the platform have either been re-written or removed. I'm going to be adding more videos in the upcoming weeks/months to replace the ones that were deleted. Thanks
Just skip to the code execution part then. It's important for people new to interviewing to understand what needs to be done prior to writing actual code. That's actually more important than writing code.
I really love your framework to tackle SQL live coding interview. I just interviewed with Uber for a SQL question, but what i did not realized is that I was not able to preview the dataset like I usually did on the platform, so I was panic and did not fully understand the question and gave wrong answer... should have watched this viz earlier lol
ah yes, I've realized that many people don't know that you typically can't preview the datasets on interviews. I've only just now started talking about solving problems without viewing the data. This video would have helped =)
![Most Common Data Science SQL Interview Question from DoorDash [window functions & partitions]](http://i.ytimg.com/vi/T1UhSuKqy3A/mqdefault.jpg)
![Most Common Data Science SQL Interview Question from DoorDash [window functions & partitions]](/img/tr.png)
where t.transaction_start_date < DATEADD(month,-10,getdate()) will this work instead of now() - 10 * interval '1 month'
they both work! depends on what sql engine you're using but both are good to use.
really great walkthroughs Nate! love StrataScratch! it's really helped me a lot
That's great! I'm glad you like the walkthrough series!
Respectfully asking for more SQL questions (especially for FB) on strata
Will keep on adding questions to StrataScratch and making these videos! I'll try to find more FB ones as I collect them!
@@stratascratch thanks! Really enjoyed my membership
thanks for the website, thanks for the content, its all a great help! providing free eduction is a noble work.
i never communicated when i solved questions like this thx
Great content. This is really helpful. Thank you Nate.
Thanks for watching! Glad you found it helpful.
Thank you , it’s so clear !
Great explanation. Excuse my question, What is 'interval' for?
Thanks for watching. Interval is used to shift a timeframe based on the interview you choose. So now()-interval '1 month' will shift the date 1 month in the past from today's date.
Always The Best
Hey I see many videos in the playlist are deleted, or may be we are not able to view it could you please look into it @Nate ?
Yes, some have been deleted as the questions on the platform have either been re-written or removed. I'm going to be adding more videos in the upcoming weeks/months to replace the ones that were deleted. Thanks
each video it takes you 10 mins to explain that you write down logic before code. we get that already, please just move on to code execution please,
Just skip to the code execution part then. It's important for people new to interviewing to understand what needs to be done prior to writing actual code. That's actually more important than writing code.
I really love your framework to tackle SQL live coding interview. I just interviewed with Uber for a SQL question, but what i did not realized is that I was not able to preview the dataset like I usually did on the platform, so I was panic and did not fully understand the question and gave wrong answer... should have watched this viz earlier lol
ah yes, I've realized that many people don't know that you typically can't preview the datasets on interviews. I've only just now started talking about solving problems without viewing the data. This video would have helped =)
i guess I am kinda off topic but does anyone know of a good place to stream newly released series online?
@Tanner Emery Flixportal :)
@Harvey Mason thank you, I went there and it seems like they got a lot of movies there :D I really appreciate it !
@Tanner Emery No problem :D