Optimizing Joins: How to Get a Distinct Count from Two Tables

Selecting Data from Nested JSONB Columns in PostgreSQL Using Regular Expressions and JSON Functions

Using Window Functions to Set Values: A Postgres Approach.

Multiplying All Values of a JSON Object with PostgreSQL 9.6 Using Recursive CTE