PulsePoint interview question

On window Functions, Query optimization and BIg Query optimization