Emma (UK) interview question

Complex join between 3 different tables in SQL