Santander interview question

Had to write down Various SQL statements