#aggregation

SQL Joins, GROUP BY, and Aggregation: The Relational Thinking Students Need

SQL is easiest to understand when you think in relations and transformations rather than translating every query into an imaginary nested loop.