UST Interview Question

SQL problem solving included joins, subqueries and nested queries