sql 50 leetcode reddit - Brave Search

Anyone know of a more advanced version of leetcode sql 50 for prep?

reddit.com › r › dataengineering › comments › 1j4jt7n › anyone_know_of_a_more_advanced_version_of

Do you _really_ want to join a company that judges folks based on "got you" style SQL questions? Honestly, that would tell me they don't know how to properly value individuals. Answer from mindvault on reddit.com

reddit.com › r/dataengineering › anyone know of a more advanced version of leetcode sql 50 for prep?

r/dataengineering on Reddit: Anyone know of a more advanced version of leetcode sql 50 for prep?

March 6, 2025 -

Hi all,

Wondering if anyone knows of something like leetcode SQL 50 but for more advanced coders that they can share? I have already completed it multiple times and trying to find a source that has very difficult sql questions to prep as I often get tricky ‘got you’ type of sql questions during code screens that are also timed so I need to practice. Please share if you have any ideas thank you.

Do you _really_ want to join a company that judges folks based on "got you" style SQL questions? Honestly, that would tell me they don't know how to properly value individuals.

Look at DataLemur , lot more focused on DE/DA and sourced from recent real job interviews at competitive companies (FB, Google, Amazon, TikTok, Airbnb)

reddit.com › r/sql › leetcode sql 50 for interview of da !!!!!!!!

r/SQL on Reddit: Leetcode SQL 50 for interview of DA !!!!!!!!

April 7, 2025 -

Hi guys,

I am in process of becoming a data analyst and I need your honest input please. Does leetcode resemble what data analyst interviews ask? I am trying to finish the Leetcode 50 SQL questions but they are really hard and overwhelming so any response will be appreciated. If you can also mention what kind of SQL skills are genuinely needed to pass the interviews, i would really appreciate it!

Most interviews focus more on writing clear, business-focused queries, working with messy data, and explaining your logic. You don’t need to complete all 50 LeetCode problems. Doing 10–15 solid ones is enough if you understand the core concepts. Then shift to the StrataScratch platform, which offers more realistic business scenarios. Focus on writing readable queries, using CTEs, and practicing real dataset problems.

Same boat, idk if it is the format of the questions or what but leetcode is pretty hard for me. So you are not alone

Videos

Challenge Accepted: Advanced SQL 50 Questions Marathon! - Data ...

February 15, 2024

Beyond Basics: 50 Advanced SQL Questions for In-Depth Understanding!

February 23, 2024

Solve Leetcode SQL 50 Questions with me | Part 1 | Master SQL for ...

SQL 50 | LEETCODE Solution Part 1 | Ashutosh Kumar - YouTube

Solve 20 Leetcode SQL Medium in 2 hours | SQL Interview Practice ...

Solve 50 SQL Questions in 2 Hours | Ultimate SQL Interview Practice ...

reddit.com › r/sql › is practicing sql questions from leetcode good enough for interviews?

r/SQL on Reddit: Is practicing SQL questions from Leetcode good enough for interviews?

June 28, 2022 -

I have to prepare for interviews and I am using free version of Strata Search and paid version of Leetcode to get the hang of it. Please let me know if that’s enough. My goal is to practice 2-4 medium and hard questions everyday and start giving interviews for next week. Appreciate any tip and help.

It’s a great start and could get you through but also depends on what you plan to do with SQL for a job. I suggest building out a database from scratch with open data sources, going from an ER diagram to database, to dashboard. Thinking about OLAP vs OLTP. Learn about 3NF, ACID, and etc. The reason is that many jobs may not require this as a necessity but your engineers will appreciate the understanding of it. The complications involved of ingesting dirty data and making it available for others to use gets lost in the background easily. I can’t think of a role that wouldn’t benefit some fundamentals of this outside of DDL/DML statements

Yeah it's okay. But Stratascratch is better.

reddit.com › r/sql › sql practice for interview

r/SQL on Reddit: SQL Practice for interview

March 16, 2024 -

Hello guys, I recently completed the leetcode 50 Sql problems and earned a badge but to be honest for the most questions I watched the solutions and completed that thing. So I am not satisfied with myself so I want to solve more like that can you guys give some website or challenges like leetcode to practice for interviews and it will be useful for everyone who seeing this post

And yeah the leetcode 50 Sql problems link is here please check it out: https://leetcode.com/studyplan/top-sql-50/

Suggest me something like this.

https://advancedsqlpuzzles.com You can try the above. There is a GitHub with a pdf of puzzles.

Use all the other interview sites Data Lemur. Pretty great, the SQL study guide Nick wrote is fantastic. The site has solid UI not cluttered or obtrusive. The best way to learn is to get to a solution and then compare your solution to the "official" solution of the problem AND look at the solution discussion section. https://datalemur.com/blog/sql-interview-guide Code Wars. Similar to the above but more user submitted questions and definitely helpful to practice targeted concepts. You can see the community voted solutions and how yours compares with great community tags. https://www.codewars.com/kata/search/sql?q=&tags=SQL&beta=false&order_by=sort_date%20desc StrataScratch. Often argued that THIS site is the LeetCode for the data community. Like LeetCode but data focused, has take homes, has great UI. Solid site, definitely worth a subscription but there's free problems too no money necessary. https://platform.stratascratch.com/coding?code_type=1&page_size=100 Interview Query. Like stratascratch, Jay is a Youtuber and provides a lot of material and help. I don't know which one is better or worse but you can check out both and their materials and pick. SQLPad. Not the IDE, yet another interview site. Analyst Builder, from Alex the Analyst. https://www.analystbuilder.com/ https://www.alextheanalyst.com/interview-prep . Also has free and paid options of questions and courses. Similar interface I think to neetcode's site. Alex is definitely more Data Analyst focus but there's a lot of cross-pollination. Data Lemur, Interview Query and SQLPad are from people who are active in the data community, I think all Ex-FAANG Data Scientists. They target getting you ready for the FAANG interviews. Stratascratch is really LeetCode for Data, more generalized than the others. I think HackerRank and LC are again more for SWEs than DS/DA/DE roles not that there's any distinction, it's just that you'll have more data focused questions in the data focused sites. If that's what you're looking for however. And these are actual interview questions, not so much SQL questions asked by a general SQL quiz. Nick has a great writeup on the distinction of that. There's nothing wrong with that for general knowledge, infact you'll be expected to know that material like Join Types and the theory etc. but you'll need to know MORE than that. Interview Questions are phrased in different ways, they won't just say "join this table to this table" or "do you know what a LEFT vs FULL is?" They expect that, they'll give you a toy business scenario and expect you to use the syntax you know to solve it.

reddit.com › r/sql › not able to solve sql 50 questions on leetcode

r/SQL on Reddit: Not able to solve sql 50 questions on leetcode

December 19, 2025 -

As the title.

I’ve just started practicing sql 50 on leetcode and I was stuck at the 5th or 6th question itself. Sometimes I feel that I wouldve been able to answer if I understood the question. The questions sometimes sound confusing there and I am not able to understand them until I see the solution.

Anybody who went through this and would have any guidance? Would really appreciate it.

Not conventional but I’d recommend going straight to the solutions of all 50 problems and understanding them as well as you can. Use an LLM to help explain it if you need. Go back and solve all the problems after a couple weeks.

Sometimes I feel that I wouldve been able to answer if I understood the question. The questions sometimes sound confusing there and I am not able to understand them until I see the solution. This is intentional. Companies that employ this purposefully ask questions that have ambiguous or misleading requirements because they expect you to ask clarifying questions about it. When solving in a vacuum that, of course, doesn't help, but part of solving such leetcode questions is to be able to interpret terse instructions, not just solve the problem.

reddit.com › r/sql › leetcode sql 50 daily challenge starting tuesday, nov 11 2025

r/SQL on Reddit: LeetCode SQL 50 Daily Challenge Starting Tuesday, Nov 11 2025

November 10, 2025 - Hi all, a small group of us is aiming to complete the LeetCode SQL 50 Study Plan by December 30th. If you would like to join this challenge, feel…

reddit.com › r/dataengineering › what i have learned by solving (almost) all the sql problems in leetcode

r/dataengineering on Reddit: What I have learned by solving (almost) all the SQL problems in Leetcode

April 12, 2023 -

Hello,

I have written my first blog post in medium about what I have learned solving leetcode SQL problems. Shared some tips for those who want to start solving SQL problems too.

Also added some resources in the post which might be beneficial for you.

Happy reading!

https://medium.com/@iamrafiul/what-i-have-learned-by-solving-almost-all-the-sql-problems-in-leetcode-670b8a2cb32e

Perhaps a hot take, but I didn't think that Leetcode's SQL questions were as good as their more traditional DS&A questions (at least when working in Python). To be honest, I still feel like there's a gap in the market for a product that focuses on teaching SQL, and particuarly teaching UNIX/Bash/Shell. While Statascratch is good, it lacked some of the edge case functionality that Leetcode has, allowing you to submit solutions that weren't really robust. The UI is also frustrating - tracking problems that I have / haven't completed shouldn't be as hard as it was.

reddit.com › r/leetcode › premium advanced sql 50

r/leetcode on Reddit: Premium Advanced SQL 50

April 14, 2024 -

Can anybody share the list of questions in this advanced SQL study plan??

thank u))

https://github.com/leetlab11/Advanced-SQL-50

Find elsewhere

Google Bing Mojeek

reddit.com › r/leetcode › how can i finish the sql50

r/leetcode on Reddit: How can i finish the sql50

March 18, 2024 -

I want to finish the sql50 on leetcode but i don't have all the knowledge in sql and problem solving using sql so i wanted a course or a playlist or anything to learn all the required syntax to finish the sql50 and if thier is any other problem solving videos for sql like training or such i would appreciate it so much thanks in advance.

Chat gpt and the Documentation of mysql/postgre/etc. W3 is good enough for the basics.

"Everyday data science" on youtube has great sql tutorials for those kind of problems

reddit.com › r/leetcode › completed sql50

r/leetcode on Reddit: Completed sql50

December 4, 2024 -

any other questions should i do, or is it gtg for interviews?

Awesome! I'm also doing sql 50 but I find my knowledge lacking in a few places.. where did you study SQL from?

Is this necessary for sde interviews if you are not into data analyst roles?

reddit.com › r/sql › sql leetcode

r/SQL on Reddit: SQL Leetcode

June 22, 2023 -

Hey everyone, so i have been solving Leetcode SQL 50, frankly speaking struggling in the medium difficulty questions sometimes even on Easy ones. Can you suggest any YouTube playlist or resource i can go through. Any other suggestions are also welcomed!

check out my playlist: https://www.youtube.com/playlist?list=PLcnOzglPJzK2RjAk19e8upv2Es4kzTN8m

reddit.com › r/sql › is purchasing leetcode premium for sql worth it?

r/SQL on Reddit: Is purchasing leetcode premium for SQL worth it?

September 30, 2024 -

Hi i wanted to ask should i purchase leetcode premium for SQL questions practice? i have already solved all the free questions and now i want to practice more but i am unable to find better quality free questions.

i am already at intermediate to advance level SQL i just need to practice for interviews.

If you guys have suggestions for any other platform for practice please let me know.

PS:- Thanks for the nice advice and support here are the best options i found going through the comments.

DataLemur

https://bilbottom.github.io/sql-learning-materials/challenging-sql-problems/challenging-sql-problems/

stratascratch

naah bro, try datalemur, it is also good sqlzoo and others sites, I have leetcode sql50 badge, its enough for placement purpose.

Will try DataLemur next time, but I got the premium sub for Leetcode last time I was interviewing so I could do both Python and SQL, and it was super helpful. I nailed any SQL interview Qs that came my way. The hardest part for me was on tough questions, not being able to really explore the data the way I would in a real database. I ended up going into Postgres and re-creating the schema to explore, and there wasn't an easy way to do it.

reddit.com › r/sql › is sql 50 study plan enough

r/SQL on Reddit: Is SQL 50 study plan enough

December 9, 2024 -

I'm trying to crack a program manager role in FAANG as well as tech startups. Is SQL 50 from leetcode enough to clear the technical round.

Note : I'm from a non- tech product based company BG

Not enough. You need multiple scenarios to build confidence. But for starters its good.

Program Manager? Is this by any chance in the description of a job you are applying for? I guess it's always good to have at least basic knowledge on tools/tech you are using. Although I cannot really gauge how much SQL you need as a program manager. Like c'mon, program managers oversee projects, coordinating teams so on and so forth. Nothing too technical no? At least in terms of querying. For a program manager position, SQL 50 is a solid starting point, but ensure you’re comfortable with how SQL would apply to the day-to-day tasks of the job. If the job is more technical, consider further practice and deepening your understanding of SQL beyond just these 50 problems. I just really don't see a program manager dwelling too deep working on SQL.

reddit.com › r/sql › getting stuck at lc sql problems

r/SQL on Reddit: Getting stuck at LC SQL problems

March 15, 2023 -

I was trying to solve LeetCode SQL 50 problems and I'm almost always getting stuck at Medium level problems. Like I get the solution but not all Test cases pass. And I feel guilty and demotivated, if I see the solution as If I can never learn SQL. So I keep banging my head and still stuck. What's the way out??? I did search on stackoverflow to find something related to the problem and keep referring syntax. But I think I lack Fundamental understanding of SQL and I'm not able to comprehend what's going on with those tables actually. What can I do to improve this? Some playist some course some real good resource for problem solving ??

If you're getting some test cases passing and some not, then you're probably on the right track but you're not considering all edge cases OR the code is too computationally inefficient to complete in the given time. I'm sure if you post the question and your answer attempt, people will be more than happy to give you hints or point out why a test case might be failing.

Might show an example

github.com › ieshreya › sql-50-leetcode

GitHub - ieshreya/sql-50-leetcode: Solutions for SQL 50 Study Plan on LeetCode · GitHub

Solutions for SQL 50 Study Plan on LeetCode · 1757 - Recyclable and Low Fat Products · SELECT product_id FROM Products WHERE low_fats = 'Y' AND recyclable = 'Y' 584 - Find Customer Referee · SELECT name FROM Customer WHERE referee_id != 2 OR referee_id IS null ·

Author ieshreya

medium.com › @hariniseetharaman24 › sql-50-by-leetcode-b2e9dbf5d387

SQL 50 By Leetcode. Solving SQL questions from Leetcode. | by Harinibala S | Medium

January 21, 2025 - However, if you do not include student_name in the GROUP BY, you may not be able to include it in the final output without causing an error. SQL requires that all selected columns that are not part of an aggregate function (like COUNT) must be included in the GROUP BY clause.

reddit.com › r/leetcode › advanced sql 50

r/leetcode on Reddit: Advanced SQL 50

June 24, 2023 - Discuss interview prep strategies and leetcode questions · Members • · RevolutionaryRoyal39 · 中文 (繁體) Hi guys ! Can anyone with premium subscription make a screenshot of Advanced SQL 50 questions? Thanks in advance ! Share · Share · Be the first to comment ·

medium.com › @lutfiandri › solving-leetcode-sql-50-question-1-3-18b980a70747

Solving LeetCode SQL-50: Question 1–3 | by Lutfi Andriyanto | Medium

June 13, 2025 - NULL in SQL is not treated as a value, but rather as a marker for an “unknown value”. Because of this, a direct comparison with NULL using operators like =, !=, >, or < will never evaluate to TRUE.

analystlaunch.com › p › live-sql-coding-interview-leetcode-sql50

Live SQL coding Interview

April 14, 2025 - This reddit thread is about the SQL50 questions. A lot of people complaining but ultimately it proves my point. Just practice the questions, and you’ll be fine. Once you get the hang of the question style, concentrate on execution speed.. ...

reddit.com › r/sql › need help: how to improve sql problem solving?

r/SQL on Reddit: Need help: How to improve SQL problem solving?

June 13, 2024 -

Hey, everyone. I have recently started learning SQL. I now understand basic select, joins, where, aggregate functions, etc. Just the basics.

And I find it really difficult to solve any problem on coding platforms. For example: I tried SQL 50 from leetcode and I got stuck on almost every question.

I really have a hard time formulating queries. I don't understand the flow. Specially I have hard time in creating group by, or any type of aggregate.

What would your suggestions be?

How to improve problem solving and logical thinking for SQL. Is there a flow I am missing? How you improved your SQL? How you practiced?

Thank you

Watch ankit bansal youtube playlist called "complex question" . I don't remember the playlist name exactly. I was facing difficulty as well but I watched his videos. It really helped me... I wasn't even able to solve the hackerrank easy question at some point but in just a week I was able to solve medium to high level (some) questions easily

Narrow your focus. I find a lot of SQL developers try to get everything they want in one go. Narrow your data sets. Filter, filter, filter. Start broad and work down to what you want. SQL is very logical. Like widdling wood, you slowly peal piece by piece till you achieve your goal. I've worked with a lot of developers, and my go to advise is always to Narrow your focus. Build from the ground up, piece by piece. Good luck.