如何计算表数据库的平均值

vjrehmav 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(277)

我想从我的数据库中计算平均值。
例如，当我运行这样的sql查询时

SELECT user.nama_u AS Nama_Siswa,
       nilai.nilai_n AS Nilai_Pelajaran
       FROM nilai,
            user
       WHERE nilai.id_sw = user.id_u
             AND user.pangkat_u = 'Siswa'
             AND nilai.kelas_n = 'I'
       ORDER BY user.nama_u DESC

我有一张这样的table

Nama_Siswa               Nilai_Pelajaran
===============          ===============     
Teuku Zul Hidayat        75
Teuku Zul Hidayat        60 
Ferry Mulia Ramadhani    100
Ferry Mulia Ramadhani    80
Apri Sara Diwa           80
Apri Sara Diwa           70

如果我想显示nilai\u pelajaran的平均值，我从上面的sql查询中修改了什么？
所以table一定是这样的

Nama_Siswa               Average
===============          ===============     
Teuku Zul Hidayat        67.5
Ferry Mulia Ramadhani    90
Apri Sara Diwa           75

sql mysql php average

来源：https://stackoverflow.com/questions/52014100/how-to-count-average-from-table-databases

1条答案

按热度按时间

huwehgph1#

只需将查询更改为使用聚合函数（在本例中 AVG )以及
GROUP BY nama_u :

SELECT user.nama_u AS Nama_Siswa, AVG(nilai.nilai_n) AS Nilai_Pelajaran 
FROM nilai
JOIN user 
WHERE nilai.id_sw = user.id_u AND user.pangkat_u = 'Siswa' AND nilai.kelas_n = 'I' 
GROUP BY user.nama_u
ORDER BY user.nama_u DESC

赞(0）回复(0）举报 2021-06-20

我来回答

如何计算表数据库的平均值

1条答案

相关问题

热门标签

最新问答