Centric Consulting Interview Question

lag, aggregate, join functions in ANSI SQL