Merge two rows into one

var query1 = from sn in code                                        
             group sn by sn.Substring(0, 10) into g
             select new
             {
               Key = g.Key,
               Cnt = g.Count(),
               Min = g.Min(v => v.Substring(10, 4)),
               Max = g.Max(v => v.Substring(10, 4))
             };
var query2 = from sn1 in codes
             group sn1 by sn1.Substring(0, 11) into g
             select new
             {
               Key = g.Key,
               Cnt = g.Count(),
               Min = g.Min(v => v.Substring(11, 4)),
               Max = g.Max(v => v.Substring(11, 4))
             };
var query3= query1.Union(query2)

SELECT ID, SUM(COL1),SUM(COL2), SUM(COL3)...
FROM TableName
Where Conditions
GROUP BY ID

Select
    EmployeeID,
    Active.IndividualPay As IndPay_IsActive,
    Active.FamilyPay As FamilyPay_IsActive,
    Inactive.IndividualPay As IndPay_IsNotActive,
    Inactive.FamilyPay As FamilyPay_IsNotActive
From
    PayTable Active
    Join PayTable Inactive On Active.EmployeeID = Inactive.EmployeeId
        And Inactive.IsActive = 'false'
Where
    Active.IsActive = 'true'