Broadridge Interview Question

sql command which involve joins