had trouble figuring out the 'in' syntax in the context of subqueries, but Bob helped me wrap my head around it