TeamViewer Interview Question

General SQL logic exercises, more specifically on JOINS