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

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, ...