Pregunta de entrevista de Pharos (Indonesia)

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