postgres: window functions

Good article about window functions. Also note how they use a postgres feature called common table expressions.