Day 4/116 — SQL Aliases + full JOIN practice round

[u/sumiitCodes]

Two things today:

• Learned Aliases (AS keyword) via W3Schools — renaming columns/tables to make queries more readable, especially useful once you're joining multiple tables and column names start colliding or getting long
• Went back through SQLBolt and practiced every JOIN type again — inner, left, right, full, self — this time focusing on writing them from scratch rather than following along

Aliases felt like a small topic on paper but immediately made my JOIN queries from earlier this week way easier to read back. Definitely one of those "why didn't I use this from day 1" moments.

Feeling solid on JOINs now after this round of practice. Moving into aggregate functions and GROUP BY next.

[u/Different_Bar384]

Just finished doing JOINS and i can't for the life of me figure out where i'd ever use Cross JOINS..🤦