TeamViewer interview question

General SQL logic exercises, more specifically on JOINS