InfoCentric Interview Question

SQL question based on sequences, joins and PL/SQL block.