NielsenIQ interview question

Basic SQL questions (join and some fuctions)