Get the app
Data Scientists
Data Scientists
on
SqueakyQuokka
SqueakyQuokka
11mo
by
Stealth

Sub-Queries & CTEs, Window Functions: A nightmare

Context: I am a Business Analyst in the logistics domain. Most of my day to day job happens on Excel/spreadsheets, to be more technically sound I started learning SQL. Till joins and in-built functions everything was fine but I really find it tough in building logic while solving interview problems related to sub queries and window functions. Is there any way through which I can get comfortable in these topics? Also are there any resources related to these topics which will help in building logic & problem solving?

11mo ago
SqueakyQuokka
SqueakyQuokka
Microsoft
11mo

It's not too hard. Think of it as creating separate tables and then joining them.

JazzyMuffin
JazzyMuffin
Novartis
11mo

Window functions can be tricky at times while dealing interview questions if you haven’t practiced well i guess.

JazzyMuffin
JazzyMuffin
Novartis
11mo

Only solution- practice

SqueakyQuokka
SqueakyQuokka
Stealth
11mo

Any resources which can be used for practising?

JazzyTaco
JazzyTaco
Infocepts
11mo

In my beginning days, hackerrank and leetcode helped a lot

FuzzyPretzel
FuzzyPretzel
Stealth
11mo

I took a datacamp course when they were offering everything free for a week / month. That really saved me with the concepts you mentioned.

Discover more
Curated from across