GROUP BY
Aggregates rows that share a column value.
GROUP BY collapses rows into groups and lets aggregate functions (COUNT, SUM, AVG, MAX, MIN) operate on each group. Every column in SELECT must either be in GROUP BY or wrapped in an aggregate.
Example
SELECT ticker, AVG(close) AS avg_price FROM equity_prices GROUP BY ticker;