23 lines (17 loc) · 994 Bytes

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/