Pergunta de entrevista da empresa Yahoo

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