Whenever you're ready, walk me through how you'd approach this.
How would you write a standard SQL query using a self join?