Understanding How to Inherit Status from Child Records in a Hierarchical Structure with SQL