Calsoft Interview Question

Window function in sql and uses.