MAQ Software interview question

An advanced SQL question involving Joins.