Stratacent Interview Question

SQL QUESTION was much prefered