Pregunta de entrevista de Inseego

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