Brian Likes Postgres

WITH releases AS (
  SELECT * FROM
  (VALUES
    ('13',  '2020-09-24'::date, '2021-02-24'::date, '2021-08-26'::date),
    ('12',  '2019-10-03'::date, '2020-03-31'::date, '2021-01-28'::date),
    ('11',  '2018-10-18'::date, '2019-03-13'::date, '2019-11-26'::date),
    ('10',  '2017-10-05'::date, '2018-02-27'::date, '2018-09-25'::date),
    ('9.6', '2016-09-29'::date, '2016-11-11'::date, '2017-10-24'::date)
  ) AS t (version, pg, rds, aurora)
)
SELECT
  version,
  pg AS "Postgres Release",
  rds AS "RDS Release",
  aurora AS "Aurora Release",
  rds - pg AS "PG -> RDS Lag",
  aurora - pg AS "PG -> Aurora Lag",
  aurora - rds AS "RDS -> Aurora Lag"
FROM
  releases
ORDER BY
  version::decimal

 version | Postgres Release | RDS Release | Aurora Release | PG -> RDS Lag | PG -> Aurora Lag | RDS -> Aurora Lag
---------+------------------+-------------+----------------+---------------+------------------+-------------------
 9.6     | 2016-09-29       | 2016-11-11  | 2017-10-24     |            43 |              390 |               347
 10      | 2017-10-05       | 2018-02-27  | 2018-09-25     |           145 |              355 |               210
 11      | 2018-10-18       | 2019-03-13  | 2019-11-26     |           146 |              404 |               258
 12      | 2019-10-03       | 2020-03-31  | 2021-01-28     |           180 |              483 |               303
 13      | 2020-09-24       | 2021-02-24  | 2021-08-26     |           153 |              336 |               183
(5 rows)