FNZ interview question

2x SQL questions, table info provided