Day21

Day 21: SQL Deep Dive — Filtering, Joins, Aggregation

📘 Topics Covered

• Data definition and alteration (CREATE TABLE, ALTER TABLE)
• Reading/filtering data (SELECT, WHERE, ORDER BY, LIMIT)
• Aggregations (COUNT, SUM, AVG, MIN, MAX) with GROUP BY and HAVING
• Joins (INNER, LEFT, RIGHT, FULL) and join conditions

📄 Scripts

See SQL/ for detailed examples:

• Table setup and inserts: SQL/table.sql, SQL/data.sql
• Reading/filtering: SQL/read.sql, SQL/datafilterion.sql
• Aggregations: SQL/dataaggregation.sql
• Alterations: SQL/altertable.sql, SQL/dataalteration.sql
• Joins: SQL/joins.sql

🔗 References

• SQL WHERE: https://www.sqltutorial.org/sql-where/
• SQL Joins: https://www.sqltutorial.org/sql-join/
• GROUP BY & HAVING: https://www.sqltutorial.org/sql-group-by/