Domanda di colloquio di Siemens

some sql questions, mainly about left join, no difficult.