본문 바로가기
English
Reports: joins with grouping

The real power comes from combining what you have learned: join two tables, group the joined rows, and summarise each group with an aggregate.

A common report is "how much has each customer spent?" — join customers to their orders, group by customer, and SUM the totals.

After a join, GROUP BY makes one summary row per group

교재 자료

로그인 또는 계정 만들기

IGCSE, A-Level & AP