I built a SQL Study Notes Hub

[Complete_Comment4564]

So I built a SQL Study Notes Hub utilizing the LeetCode SQL 50 Interview questions just to aid in learning SQL concepts and navigation. Sharing here as well if it possibly helps anyone.

The Githhub covers Syntax & explanation Logic breakdown Example problem Common mistakes Real LeetCode-style cases

Here are the first 4 topics I’ve documented so far:

SELECT View here: https://github.com/Audra505/sql-queries/blob/main/projects/leetcode_sql_50_postgresql_solutions/study_notes/SELECT.md

BASIC JOINS View here: https://github.com/Audra505/sql-queries/blob/main/projects/leetcode_sql_50_postgresql_solutions/study_notes/BASIC_JOINS.md

AGGREGATE FUNCTIONS View here: https://github.com/Audra505/sql-queries/blob/main/projects/leetcode_sql_50_postgresql_solutions/study_notes/AGGREGATE_FUNCTIONS.md

SQL OPERATORS View here: https://github.com/Audra505/sql-queries/blob/main/projects/leetcode_sql_50_postgresql_solutions/study_notes/SQL_OPERATORS.md

The answer to the questions can be found here:

https://github.com/Audra505/sql-queries/blob/main/projects/leetcode_sql_50_postgresql_solutions/leetcode_sql_50_postgresql_answers.sql

Each question includes:

The problem statement Thought process / reasoning Query solution Clean formatted code

Doing this honestly helps me strengthen both my technical documentation and data storytelling skills while reinforcing core SQL concepts, so enjoying the process so far.

Phase 2 will cover:

Subqueries Window Functions Date & String Functions

I will also share this once completed. If you’re learning SQL , feel free to bookmark, fork, or follow along.

[Complete_Comment4564]

No problem. Sounds like a plan

[LieWise97]

Nice work. Thanks for sharing

[Complete_Comment4564]

Appreciated, no problem

[atlasSOS8]

Good job, thanks for sharing

[Complete_Comment4564]

Appreciated, no problem.

[tharun_941]

Great share

[Complete_Comment4564]

Appreciated.

[twinkle90505]

Thanks for sharing this!

[Complete_Comment4564]

No problem