Hacker News Reader

Comment by thomzi12 | Hacker News Reader

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!

View on HN

Leetcode has some SQL problems that I’ve found useful in interview prep: https://leetcode.com/problemset/database/

Great 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

I 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.

For cumulative averages why not use window functions?

Good catch -- I can add that in as an alternate solution. Thanks!

Of course!

Now the thing to do is for me to recreate your list on github.

Yes -- making this a proper webpage with an embedded SQL editor like selectstarsql.com does would be a good next step

Are there any good ways to embed SQL in markdown? Like JupyterLab notebooks?

Yes, 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/noteb...

Thanks! I'll have to check that out.

Great resource. Thanks for sharing. Do you have any more resource recomondations besides the ones in the article? Maybe a book?

We try to surface the best SQL interview questions at Interview Query (https://www.interviewquery.com/)

Hello, how come you chose to use quip over Google docs? I'd expect you to choose the latter since you work for Google.

Yeah, 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 :/

Reply on news.ycombinator.com