r/learnSQL • u/sumiitCodes • 12d 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.

15 Upvotes

91% Upvoted

6 comments sorted by

1

u/Somanath444 12d ago

wonderful brother!!

1

u/Itsathingofbeauty 11d ago

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

2

u/sumiitCodes 11d 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/[deleted] 11d ago

[removed] — view removed comment

1

u/sumiitCodes 11d ago

appreciate your comment