UST interview question

SQL problem solving included joins, subqueries and nested queries