CData interview question

Questions related to SQL, mostly on window functions