Emma (UK) Interview Question

Complex join between 3 different tables in SQL