Question d’entretien chez IBM

Given the schema of a database, write an SQL query