Pergunta de entrevista da empresa Pinterest

Write a SQL code that extracts certain information from three tables.