Wise Interview Question

SQL subquery which uses 3 tables