Indium Software interview question

questions using window functions of the SQL