FNZ Interview Question

2x SQL questions, table info provided