Pregunta de entrevista de TeamViewer

General SQL logic exercises, more specifically on JOINS