9. How do the basic SQL arithmetic operators (+, -, etc.) differ from the aggregation (SUM, etc.) commands?
They operate on data only within a row (ignoring the new Lag/Lead operators). Aggregators such as SUM operate across all rows, or all rows within a selected group.