InfoCentric interview question

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