Eng 6695 partial agg for ordered subquery

Really? What about 

    select R.parent_id, P.child_id
    from R LEFT JOIN P on R.parent_id = P.parent_id
    where R.parent_id > 100;