Stratacent interview question

SQL QUESTION was much prefered