Thanh Phương
New member
Câu lệnh SQL nào sử dụng để tính điểm thi trung bình cho bài kiểm tra số 1?
A. SELECT AVG(DIEM_KT) FROM KETQUA_KIEMTRA;
B. SELECT AVG(DIEM_KT) FROM KETQUA_KIEMTRA WHERE ID_BAIKT = 1;
C. SELECT AVG(DIEM_KT) FROM KETQUA_KIEMTRA GROUP BY ID_BAIKT;
D. SELECT COUNT(DIEM_KT) FROM KETQUA_KIEMTRA WHERE ID_BAIKT = 1;
A. SELECT AVG(DIEM_KT) FROM KETQUA_KIEMTRA;
B. SELECT AVG(DIEM_KT) FROM KETQUA_KIEMTRA WHERE ID_BAIKT = 1;
C. SELECT AVG(DIEM_KT) FROM KETQUA_KIEMTRA GROUP BY ID_BAIKT;
D. SELECT COUNT(DIEM_KT) FROM KETQUA_KIEMTRA WHERE ID_BAIKT = 1;