title: Help with writing a SQL query for Nested Sets
body: <p>I'm storing a tree in a DB using nested sets.  The table's fields are id, lft, rgt, and name.  </p>
  
  <p>Given a node ID, I need to find all of its direct children(not grandchildren) that are themselves leaf nodes.</p>