4 ms·
Hey, HN! Since I couldn't find a good resource online for the self-join and window function SQL questions I've encountered over the years in interviews, I made
by thomzi12 6y ago
Hey, HN! Since I couldn't find a good resource online for the self-join and window function SQL questions I've encountered over the years in interviews, I made my own study guide which I'm now sharing publicly as a Quip doc. Would love your feedback or thoughts!
- mobileexpert 6y agoLeetcode has some SQL problems that I’ve found useful in interview prep: https://leetcode.com/problemset/database/ https://leetcode.com/problemset/database/
- thomzi12 6y agoGreat resource! I have personally found the top Leetcode SQL questions to be hit-or-miss without curation (too easy, too hard, doesn't cover topics like window functions / self-joins like I would encounter in interviews, etc.) but you're right, it is a great, interactive interview resource
- bogomipz 6y agoI enjoyed reading this. My feedback is that although a few of the problems had links to blog posts that provided some analysis of the problem and solution most of these did not. I think if you added a short analysis or explanation of what makes the problem tricky and the thinking behind the solution it would be very beneficial.
- beckingz 6y agoFor cumulative averages why not use window functions?
- thomzi12 6y agoGood catch -- I can add that in as an alternate solution. Thanks!
- beckingz 6y agoOf course! Now the thing to do is for me to recreate your list on github.
- thomzi12 6y agoYes -- making this a proper webpage with an embedded SQL editor like selectstarsql.com does would be a good next step
- beckingz 6y agoAre there any good ways to embed SQL in markdown? Like JupyterLab notebooks?
- cbcoutinho 6y agoYes, Azure Data Studio allows you to embed SQL in notebooks right out of the box: https://docs.microsoft.com/en-us/sql/azure-data-studio/notebooks-guidance?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/azure-data-studio/noteb...
- beckingz 6y agoThanks! I'll have to check that out.
- deleted 6y ago[deleted]
- rollinDyno 6y agoHello, how come you chose to use quip over Google docs? I'd expect you to choose the latter since you work for Google.
- thomzi12 6y agoYeah, it's because (1) I started this doc over a year ago when I was still at Salesforce (which owns/employees use Quip) and (2) AFAIK Google Docs still doesn't have native code block support :/
- pwesner 6y agoGreat resource. Thanks for sharing. Do you have any more resource recomondations besides the ones in the article? Maybe a book?
- data4lyfe 6y agoWe try to surface the best SQL interview questions at Interview Query (https://www.interviewquery.com/ https://www.interviewquery.com/)