Pergunta de entrevista da empresa Pharos (Indonesia)

Write an SQL query to extract specific information from multiple joined tables.