On: Medium-hard SQL interview questions

[thomzi12]

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 → thomzi12]

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

[thomzi12 → mobileexpert]

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

[bogomipz → thomzi12]

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.

[beckingz → thomzi12]

For cumulative averages why not use window functions?

[thomzi12 → beckingz]

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

[beckingz → thomzi12]

Of course!

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

[thomzi12 → beckingz]

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

[beckingz → thomzi12]

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

[cbcoutinho → beckingz]

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

[beckingz → cbcoutinho]

Thanks! I'll have to check that out.

[pwesner → thomzi12]

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

[data4lyfe → pwesner]

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

[rollinDyno → thomzi12]

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

[thomzi12 → rollinDyno]

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