Yahoo Interview Question

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