Recursive Queries

  1. Find the upward recommendation chain for member ID 27
  2. Find the downward recommendation chain for member ID 1
  3. Produce a CTE that can return the upward recommendation chain for any member