Inseego interview question

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