Help Building JQL to Keep Status of Parent-Child Work Items in Alignment

[Mathew Lederman]

I need help building 2 queries:

1. Find parent-level work items where
   1. Parent-Level work item is not Done (statusCategory != Done) AND
   2. All sub-task work items are Done (statusCategory = Done)
2. Find all sub-task level work items where
   1. Parent-Level work item is Done (statusCategory = Done) AND
   2. All sub-task work items are not Done (statusCategory != Done)

Ideally, I'd like to only use natively available JQL so I can use these queries to build filters/dashboards.