Great repo – @cpursley!!
I would suggest adding this 5-part blog series Advanced Data Science with PostgreSQL Window Functions: :
https://data-nerd.blog/tag/window-functions/
cover ranking, rolling statistics, gap/islandAnd more—pure SQL, no external tooling. can fit under Analytics with PostgreSQL or Advanced SQL.
<a href