如何在mysql中按每个日期对字段进行求和

我正在尝试根据案件的日期查询QUERY总计字段罚款，何时但不成功，有解决方案吗？

我的桌子

NIP     NAMA                  TANGGAL     JENIS_KEHADIRAN     DENDA
10016   Novi Irawati          2020-01-03    sakit             37500
10016   Novi Irawati          2019-12-19    ijin              50000
10016   Novi Irawati          2019-12-19    ijin              50000
10010   Muhammad Hayyi         2019-12-15   hadir             0
10011   Rifyal Ainul Yaqin    2019-12-16    hadir   0
10012   Misbahul Munir        2019-12-20    hadir   0
10013   Ari Arif Sholeh       2019-12-20    hadir   0
10014   Sopantoni Hendri C    2019-12-20    hadir   0
10015   Alfan                 2019-12-20    hadir   0
10017   Romiatul Jamil        2019-12-20    hadir   0
10018   Fidatul Hasanah       2019-12-20    hadir   0
10019   Abdul Muik            2019-12-20    hadir   0

我的查询

select nip,nama,case
when month(tanggal) = month(tanggal) then sum(denda)
end as total_denda
from potongan_absen
group by nip

表I求和后

NIP     NAMA                  TANGGAL     JENIS_KEHADIRAN     DENDA
10016   Novi Irawati          2020-01-03    sakit             37500
10016   Novi Irawati          2019-12-19    ijin              100000
10010   Muhammad Hayyi         2019-12-15   hadir             0
10011   Rifyal Ainul Yaqin    2019-12-16    hadir   0
10012   Misbahul Munir        2019-12-20    hadir   0
10013   Ari Arif Sholeh       2019-12-20    hadir   0
10014   Sopantoni Hendri C    2019-12-20    hadir   0
10015   Alfan                 2019-12-20    hadir   0
10017   Romiatul Jamil        2019-12-20    hadir   0
10018   Fidatul Hasanah       2019-12-20    hadir   0
10019   Abdul Muik            2019-12-20    hadir   0