BNY On-Campus OA 2026 | Database Assessment | Mortgage Maturity Dates | Bond Cash Flow | Complete Solutions & Tips | Advanced SQL Aggregations & Finance | Jan 22nd Campus Assessment

Question 1: Mortgage Maturity Dates Problem Statement: Assess the maturity dates associated with mortgages within mortgage-backed securities for a team of financial analysts. The result should include these columns: name - name of the bond maturities - total number of maturity dates for a specific bond earliest_maturity - earliest maturity date for a specific bond latest_maturity - latest maturity date for a specific bond avg_days_to_maturity - average days to maturity for a specific bond, rounded to the nearest whole number, ...