Introduction When you’re querying your PostgreSQL database, using aggregate functions can help you group your result set in more meaningful ways. With the help of functions like SUM(), COUNT() and AVG(), you can gain better insights into your data. In this article, we’ll take a closer look at these functions and show you how to … Continued

Introduction In this lesson we learn how to use the following Postgres aggregate functions: AVG function and SUM function, which are both aggregate functions in PostgreSQL. We also explore a statement required for filtering of aggregated data; “HAVING”. Prerequisites An understanding of how SQL queries fit into the Postgres database system and the means to … Continued