5.32Other aggregate concepts

Recognize:

COUNT
SUM
AVG
MIN
MAX
GROUP BY

Example:

SELECT StageName, COUNT(Id)
FROM Opportunity
GROUP BY StageName

Conceptual result:

Prospecting       127
Proposal           48
Negotiation        32
Closed Won         89

For Mule integration development, aggregate SOQL tends to matter more for:

reporting
reconciliation
monitoring
decision logic

than basic CRUD.