如何通过结合两个CTE获得理想的结果？

I have two CTE's,firstly

我有两个CTE,首先是

  ;WITH CTE AS (SELECT A.* 
                    , Row_NUMBER() Over (Partition by ID order by Date asc) RN 
             FROM TABLE A)
    SELECT Sum(Weight) as IN_WT
    FROM CTE 
    WHERE RN = 1 and name='dev1'
  ;WI