window-functions-deep-dive
1Master 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 co
window
functions
deep
dive
Also installable via skills CLI
npx skills add rustomax/observe-community-mcp/skills/window-functions-deep-dive