Mollie interview question

SQL question with joins, having, etc