ING Interview Question

Oracle question on table joins