Deutsche Bank Interview Question

Write an SQL code based on an ERD