Pergunta de entrevista da empresa AppTcom

How we get this result between those tables from the database? (pseudo code question)