Eng 6695 partial agg for ordered subquery