ING interview question

Oracle question on table joins