FNZ Interview Question

SQL related question based on provided tables