Dice Enterprises Pvt Ltd. interview question

Write a subquery using SQL