Pergunta de entrevista da empresa buynomics

sql question about was self joining table A with itself then making it join with another table B. then show some fields from both