Sogeti Interview Question

The Unit Manager gave a scenario with imaginary tables and asked me how would I go about solving this SQL problem.