this ain't cutting it. sub-groups are not captured in the `cohort_master_group` table. 

you'll have to go through the `root_group_of_group` function to first get the root group of a given sub-group, then do the lookup and update based on that.