CommerceIQ interview question

1. SQL window functions ?