Centric Consulting interview question

lag, aggregate, join functions in ANSI SQL