Streams Tech interview question

problem solving, sql queries, design pattern, architecure question, c# and .net deep level understanding