Question d’entretien chez Inseego

Given two related data tables and wanted to write a SQL query?