window-functions-deep-dive
Master OPAL window functions for row-relative calculations, rankings, and moving aggregates. Covers lag(), lead(), row_number(), rank(), dense_rank(), moving averages, first(), and last(). Use when comparing rows to neighbors, ranking within partitions, calculating rate of change, or computing time-based moving windows. CRITICAL - OPAL uses window() function wrapper, NOT SQL OVER clause.
sql-analytics
Master analytical SQL including window functions, CTEs, aggregations, and query optimization for BI workloads
postgresql-advanced-queries
Master advanced PostgreSQL queries - CTEs, window functions, recursive queries
sql-patterns
Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strategy, pagination sql.
