Deutsche Bank interview question

Write an SQL code based on an ERD