Domanda di colloquio di Servosys Solutions

sql join, and one logical tricky question