Finastra Interview Question

oops,sql queries, puzzles