4 entries.
Running totals, rankings and "compare each row to its group" — all without a self join.
If you can write a SELECT, you are most of the way there. The rest is file layout and two macros.
Freshness and row-count checks written as dbt tests, surfaced on a single page. No new vendor.
dbt · data-engineering · sql
The same operation in both, side by side. For when you know one and are reaching for the other.
python · sql · pandas