A few tools, each one explained properly
A working engineer's toolbox. Not the hundredth Base64 encoder — each tool takes a problem you hit occasionally and have to re-learn every time, explains how it actually works, and gives you something that computes.
Drag the data distribution on the left; watch which path Postgres picks on the right — and how far you are from a different answer.