The aggregation functions you can use in a QUERY formula are avg (), count (), max (), min (), and sum (). The clause types are select, where, group by, pivot, order by, limit, offset, label, format, ...

For years, one of the key areas where Google Sheets has lagged behind Microsoft Excel has been its native table functionality ...