Inseego Interview Question

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