SELECT
MaHH,
SUM(T1) AS T1,
SUM(T2) AS T2,
SUM(T3) AS T3,
SUM(T4) AS T4,
SUM(T5) AS T5,
SUM(T6) AS T6,
SUM(T7) AS T7,
SUM(T8) AS T8,
SUM(T9) AS T9,
SUM(T10) AS T10,
SUM(T11) AS T11,
SUM(T12) AS T12,
SUM(Temp.Nam) AS Nam
FROM
(
    SELECT
    MaHH,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=1),0) AS T1,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=2),0) AS T2,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=3),0) AS T3,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=4),0) AS T4,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=5),0) AS T5,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=6),0) AS T6,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=7),0) AS T7,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=8),0) AS T8,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=9),0) AS T9,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=10),0) AS T10,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=11),0) AS T11,
        ISNULL((SELECT SUM(SoLuong) WHERE MONTH(NgayBan)=12),0) AS T12,
        ISNULL(SUM(SoLuong),0) AS Nam
    FROM HOADONBANHANG FULL JOIN CT_HOADON
    ON HOADONBANHANG.MaHD = CT_HOADON.MaHD
    WHERE YEAR(NgayBan) = 2017
    GROUP BY MONTH(NgayBan),MaHH
) AS Temp
GROUP BY Temp.MaHH