Yahoo interview question

Some complex DB query requiring multiple joins (don't remember exactly)