เป็นคำถามเกี่ยวกับการใช้คำสั่ง sql ครับ ช่วยเข้ามาแนะนำหน่อยครับ

        string[][] dataArray = new string[][]
        {
            new string[] { "001", "06", "01", string.Empty },
            new string[] { "001", "06", "02", "คอมพิวเตอร์" },
            new string[] { "001", "07", "01", string.Empty },
            new string[] { "001", "07", "02", "ฟังเพลง" }
        };

        DataTable dtData = new DataTable();
        dtData.Columns.Add(new DataColumn("user_id", typeof(string)));
        dtData.Columns.Add(new DataColumn("type_code", typeof(string)));
        dtData.Columns.Add(new DataColumn("sub_type_code", typeof(string)));
        dtData.Columns.Add(new DataColumn("remark", typeof(string)));

        foreach (string[] data in dataArray)
        {
            DataRow drNew = dtData.NewRow();
            drNew["user_id"] = data[0];
            drNew["type_code"] = data[1];
            drNew["sub_type_code"] = data[2];
            drNew["remark"] = data[3];

            dtData.Rows.Add(drNew);
        }

        var myData = from u in dtData.AsEnumerable()
                     group u by u.Field<string>("user_id") into gp
                     select new
                     {
                         F6_1 = gp.Where(x => x.Field<string>("type_code") == "06" && x.Field<string>("sub_type_code") == "01").Select(x => x.Field<string>("sub_type_code")).First(),
                         F6_2 = gp.Where(x => x.Field<string>("type_code") == "06" && x.Field<string>("sub_type_code") == "02").Select(x => x.Field<string>("sub_type_code")).First(),
                         F6_2_name = gp.Where(x => x.Field<string>("type_code") == "06" && x.Field<string>("sub_type_code") == "02").Select(x => x.Field<string>("remark")).First(),
                         F7_1 = gp.Where(x => x.Field<string>("type_code") == "07" && x.Field<string>("sub_type_code") == "01").Select(x => x.Field<string>("sub_type_code")).First(),
                         F7_2 = gp.Where(x => x.Field<string>("type_code") == "07" && x.Field<string>("sub_type_code") == "02").Select(x => x.Field<string>("sub_type_code")).First()
                     };

        GridView1.DataSource = dtData;
        GridView1.DataBind();

        GridView2.DataSource = myData.ToList();
        GridView2.DataBind();

WITH USER_SUM AS
(
	SELECT TOP 100 USER_ID ,
	SUM(CASE WHEN [type_code] = '06' and [sub_type_code] = '01' THEN 1 ELSE 0 END) AS F6_1,
	SUM(CASE WHEN [type_code] = '06' and [sub_type_code] = '02' THEN 2 ELSE 0 END) AS F6_2,
	SUM(CASE WHEN [type_code] = '07' and [sub_type_code] = '01' THEN 1 ELSE 0 END) AS F7_1,
	SUM(CASE WHEN [type_code] = '07' and [sub_type_code] = '02' THEN 2 ELSE 0 END) AS F7_2,
	(SELECT [remark] + ',' FROM USER_SUB_DTL u2 WHERE u2.user_id = u1.user_id AND u2.remark <> '' FOR XML PATH('')) AS Remark
	FROM USER_SUB_DTL u1
	GROUP BY USER_ID 
)
SELECT USER_ID, F6_1, F6_2, F7_1, F7_2, SUBSTRING(Remark, 0, LEN(Remark)) AS Remark FROM USER_SUM 

var rhh = from rh in IResearch
    join c in ICheckStatus on rh.ID_Research equals c.ID_Research into JoinedEmpDept1
    from c in JoinedEmpDept1.DefaultIfEmpty()
    join s in IStatusTasks on c.ID_StatusTask equals s.ID_StatusTask into JoinedEmpDept
    from s in JoinedEmpDept.DefaultIfEmpty()
       select new 
       {
         ResearchNo = rh.ResearchNo, //รหัสโครงการ
         ResearchN = rh.ResearchN, //ชื่องานวิจัย
         Yearbudget = rh.Yearbudget, //ปี
         StastusTask = s.StatusTask1, //สถานะ
       };
GridView3.DataSource = rhh.ToList();
GridView3.DataBind();

SELECT Research.*, CheckStatus.*,StatusTask.StatusTask
  FROM [Irdbase].[dbo].[Research]
  LEFT OUTER JOIN [Irdbase].[dbo].[CheckStatus] ON Research.ID_Research = CheckStatus.ID_Research
  LEFT OUTER JOIN [Irdbase].[dbo].[StatusTask] ON CheckStatus.ID_StatusTask = StatusTask.ID_StatusTask