Pregunta de entrevista de Oracle

Basics of some SQL joins. Some basic algorithms.