In this article, we'll discuss a case of PostgreSQL time-series data by generating year-on-year and period-over-period comparisons.