I think they were probably testing your knowledge of Joins, it would be interesting to see what you think the solution is before putting up how I would have coded.