Pergunta de entrevista da empresa SG Digital

Write a join SQL query for some records, then optimise it