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

ChatGPT is a chatbot that you can learn how to use in minutes. Here are some easy ways to get started.