New posts in distinct-on

Selecting rows ordered by some column and distinct on another

postgresql greatest-n-per-group distinct-on

Multiple DISTINCT ON clauses in PostgreSQL

sql postgresql duplicates distinct-on

PostgreSQL DISTINCT ON with different ORDER BY

sql postgresql sql-order-by distinct-on