Question d’entretien chez Pharos (Indonesia)

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