NielsenIQ interview question

Intermediate SQL questions include window and joins.