var vhcChkLists = await _db.TblVehicleCheckListDetails
                .GroupBy(p => p.AssignedVehicleCheckList)
                .Select(p => new
                {
                    AnsweredQuestion = p.Where(c => c.Answer != null).Count(),
                    NoQuestion = p.Where(c => c.Answer == 2).Count(),
                    TotalQuestion = p.Count(),
                    p.Key.ASSTCode,
                    p.Key.CheckDate,
                    p.Key.CreatedBy,
                    p.Key.Id,
                    p.Key.OdometerReading,
                    p.Key.TruckUnit,
                    p.Key.Comments,
                    p.Key.PCCode
                })
                .OrderByDescending(p => p.Id)
                .ToListAsync();

SELECT 
    [Project2].[Id] AS [Id], 
    [Project2].[C2] AS [C1], 
    [Project2].[C3] AS [C2], 
    [Project2].[C1] AS [C3], 
    [Project2].[ASSTCode] AS [ASSTCode], 
    [Project2].[CheckDate] AS [CheckDate], 
    [Project2].[CreatedBy] AS [CreatedBy], 
    [Project2].[OdometerReading] AS [OdometerReading], 
    [Project2].[TruckUnit] AS [TruckUnit], 
    [Project2].[Comments] AS [Comments], 
    [Project2].[PCCode] AS [PCCode]
    FROM ( SELECT 
        [Project1].[C1] AS [C1], 
        [Project1].[Id] AS [Id], 
        [Project1].[CheckDate] AS [CheckDate], 
        [Project1].[TruckUnit] AS [TruckUnit], 
        [Project1].[PCCode] AS [PCCode], 
        [Project1].[OdometerReading] AS [OdometerReading], 
        [Project1].[ASSTCode] AS [ASSTCode], 
        [Project1].[CreatedBy] AS [CreatedBy], 
        [Project1].[Comments] AS [Comments], 
        [Project1].[C2] AS [C2], 
        (SELECT 
            COUNT(1) AS [A1]
            FROM [dbo].[TblVehicleCheckListDetails] AS [Extent4]
            WHERE (([Project1].[Id] = [Extent4].[AssignedVehicleCheckListId]) OR (1 = 0)) AND (2 = [Extent4].[Answer])) AS [C3]
        FROM ( SELECT 
            [GroupBy1].[A1] AS [C1], 
            [GroupBy1].[K1] AS [Id], 
            [GroupBy1].[K2] AS [CheckDate], 
            [GroupBy1].[K3] AS [TruckUnit], 
            [GroupBy1].[K4] AS [PCCode], 
            [GroupBy1].[K6] AS [OdometerReading], 
            [GroupBy1].[K7] AS [ASSTCode], 
            [GroupBy1].[K8] AS [CreatedBy], 
            [GroupBy1].[K10] AS [Comments], 
            (SELECT 
                COUNT(1) AS [A1]
                FROM [dbo].[TblVehicleCheckListDetails] AS [Extent3]
                WHERE (([GroupBy1].[K1] = [Extent3].[AssignedVehicleCheckListId]) OR (1 = 0)) AND ([Extent3].[Answer] IS NOT NULL)) AS [C2]
            FROM ( SELECT 
                [Extent2].[Id] AS [K1], 
                [Extent2].[CheckDate] AS [K2], 
                [Extent2].[TruckUnit] AS [K3], 
                [Extent2].[PCCode] AS [K4], 
                [Extent2].[CheckedBy] AS [K5], 
                [Extent2].[OdometerReading] AS [K6], 
                [Extent2].[ASSTCode] AS [K7], 
                [Extent2].[CreatedBy] AS [K8], 
                [Extent2].[CreatedOn] AS [K9], 
                [Extent2].[Comments] AS [K10], 
                COUNT(1) AS [A1]
                FROM  [dbo].[TblVehicleCheckListDetails] AS [Extent1]
                INNER JOIN [dbo].[TblVehicleCheckLists] AS [Extent2] ON [Extent1].[AssignedVehicleCheckListId] = [Extent2].[Id]
                GROUP BY [Extent2].[Id], [Extent2].[CheckDate], [Extent2].[TruckUnit], [Extent2].[PCCode], [Extent2].[CheckedBy], [Extent2].[OdometerReading], [Extent2].[ASSTCode], [Extent2].[CreatedBy], [Extent2].[CreatedOn], [Extent2].[Comments]
            )  AS [GroupBy1]
        )  AS [Project1]
    )  AS [Project2]
    ORDER BY [Project2].[Id] DESC