NexJ Systems Interview Question

Construct a SQL query to extract some piece of information from the two tables given.