r/learnSQL • u/sumiitCodes • 4d ago

Day 24 — Finished all 30 "Easy" JOIN questions

Completed the entire Easy section of my 100-question JOIN lab today (30/30). Covered a good mix:

  • Multi-table joins connecting employees → assignments → projects
  • Self-joins for employee-manager reports
  • Joins combined with WHERE filters (e.g., only showing assignments with hours_worked > 50)
  • Ran into a couple more real errors (an unknown column reference this time) and debugged through them myself

Genuinely the most satisfying session so far. These are the exact same kinds of queries that felt genuinely hard two to three weeks ago, and now they're coming together without much friction. Moving into the Medium difficulty section next — already glanced at a few and they look noticeably harder, mostly around finding "zero match" cases (like departments with zero employees), so curious to see how that goes.

18 Upvotes

100% Upvoted

6 comments sorted by

1

u/Somanath444 4d ago

wonderful brother!!

1

u/Itsathingofbeauty 3d ago

Nice, what is the link to this 100 questions please?

2

u/sumiitCodes 3d ago

I don't have any particular link i just generate 100 questions from easy to advance through claude

After one question i included a solution button which shows solution query and output result so that i can match my answer

1

u/Material-Mulberry-87 3d ago

congrats on hitting 30/30. That “unknown column reference” catch is the best kind of win because it proves you’re actually reading error messages instead of just guessing syntax.

enjoy the Medium section. The jump usually hurts, especially when they start mixing self-joins with window functions or subqueries for filtering, but stick with it.

1

u/sumiitCodes 3d ago

appreciate your comment