IBM Interview Question

Given the schema of a database, write an SQL query