Google interview question

Basic to intermediate SQL questions on windows functions and nested queries