Oracle Interview Question

there was some DS Algo question medium level, some SQL query and one DB schema design