PinnedInCode Like A GirlbyLuchiana Dumitrescu·May 15, 2025SQL Views vs Temporary Tables: Explained with Real-Life AnalogiesLet’s be honest — we’ve all done it. I used to rewrite the same complex query over and over when I started learning SQL, thinking it would…A response icon4A response icon4
PinnedInCode Like A GirlbyLuchiana Dumitrescu·Aug 28, 2024FIRST_VALUE and LAST_VALUE in SQL: Capturing the Start and End Points of Your Data JourneyYou can still enjoy the full article for free if you're not a Medium member. Click here to read it all😊A response icon2A response icon2
PinnedInCode Like A GirlbyLuchiana Dumitrescu·Jul 10, 2024SQL Essentials: RANK or DENSE_RANK? That’s the questionIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊A response icon3A response icon3
PinnedInCode Like A GirlbyLuchiana Dumitrescu·Jun 26, 2024SQL Essentials: GROUP BY vs. PARTITION BY explainedIf you’re not a Medium member, you can still enjoy the full article for free. Click here to read it all 😊A response icon15A response icon15
PinnedInCode Like A GirlbyLuchiana Dumitrescu·Jun 13, 2024SQL Window Functions: The Ultimate Tool for Data EnthusiastsVast amounts of data — this is what we’re dealing with nowadays. Along with this main challenge comes the complexity of various sources…A response icon6A response icon6
InCode Like A GirlbyLuchiana Dumitrescu·Oct 28COUNT(*) vs COUNT(column): What Are You Actually Counting?The case of the empty cinema seats and how the Spider-Man movie helped me explain the differenceA response icon2A response icon2
InCode Like A GirlbyLuchiana Dumitrescu·Aug 13Table-Valued Functions in SQL: Turning Requests Into Data TablesI’m pretty sure all of us know how going out for dinner works. And no, I’m not talking about all the preparations before leaving the house…
InCode Like A GirlbyLuchiana Dumitrescu·Jul 9SQL Cross Apply — When SQL Thinks Like a Recommendation EngineAh, online shopping is a blessing for us and a nightmare for our bank accounts (which is also ours, but the temptation is stronger🙃)A response icon1A response icon1
InCode Like A GirlbyLuchiana Dumitrescu·Jun 1Can parenting chaos explain SQL Anti-Joins? I say: Of courseBeing a parent is both a pure blessing and, sometimes, a complete nightmare — especially when you take your little one to the store.A response icon1A response icon1
Luchiana Dumitrescu·May 9Game Night Matching and SQL SELF JOIN? Can it be that simple?A beginner-friendly guide to understanding SELF JOIN by matching people, not just data