I told them avg, sum , lag are not analytic functions and if they want to know windowing functions but they didn't want to explain their questions. They wanted me to be a mind reader.