Pergunta de entrevista da empresa Jet

Write the SQL code for joining these two tables.