Addverb Technologies interview question

SQL queries, Gave the problem statement to write the code on any language