Understanding SQL Aggregate Functions

This is an external article made in collaboration with another source. Click the button below the view the whole article.

You may have heard that “data is the new oil.” By itself, data is unrefined and not valuable, but given processing and refinement, it becomes precious. We gain insights into our products, applications, and customers by exploring our data. PostgreSQL exposes aggregate functions that give us the tools to transform and process our data to provide meaning.

In this article, we’ll take a look at how to use SQL aggregate functions, the pitfalls, and how Timescale gives us advanced tooling to aggregate time-series data.