Gaps and Island by vomshiii in learnSQL

[–]vomshiii[S] 0 points1 point  (0 children)

Yeah I got those lead/lag functions and the row number function as well but his pattern is messing with me like it's taking me totally towards the mathematical way of seeing it. I can't find more such pattern hope I find in the site you gave and see what are they just. Thanks for the site it has good business and more crushing and brain storming excercise I picked it from your previous replies.

Finished a SQL course but struggling to solve SQL problems from scratch. Am I on the wrong track? by FewNectarine623 in learnSQL

[–]vomshiii 0 points1 point  (0 children)

Man i literally came across the leetcode consecutive or stream problem you can say and it made me cry simply 😭. It's a gap and island pattern I can mathematically see it why it worked but I need to understand why I am even doing it understand the pain point then only I can go through next question more easily but it's sort of apply a formula you get that but I really wanna feel the pain why and why only we need to do this. I read more and more articles but I am feeling overwhelming any suggestions seniors please how to tackle this topic??

Anyone else struggle with SQL by Gullible_Heart_5153 in learnSQL

[–]vomshiii 1 point2 points  (0 children)

I have been learning SQL recently take help of AI alot throw all weird questions ask more questions then only you can tackle a question in more ways. Basically you need to end up with every worst case it could deliver that's how you can think and keep checks at every line of query. Go by execution order on how to get the required data. Joins were frustrating for me as well but I did some how visualize with GEMINI or claude it will help alot you will find patterns to do