absolutely need to improve on the semi join reduction applied to aggregation