Câu 2 Phần II

UPDATE HOCVIEN
SET DIEMTB =
(
    SELECT AVG(DIEM)
    FROM KETQUATHI KQ1
    WHERE LANTHI =
    (
        SELECT MAX(LANTHI)
        FROM KETQUATHI KQ2
        WHERE (KQ1.MAHV = KQ2.MAHV AND KQ1.MAMH = KQ2.MAMH)
        GROUP BY MAHV,MAMH
    )
    AND KQ1.MAHV = HOCVIEN.MAHV
)