如何在mysql中找到2个数据的减号？

Question

I'm using this code to find sum. I want to ask how to (-) data from total_bayaran and total_denda from this code

select nama_penerjemah, nama_projek, SUM(bayaran) AS total_bayaran, SUM(denda) AS TOTAL_denda 
FROM tbl_episode 
GROUP BY nama_penerjemah, nama_projek

For example I have data 200 and 100
so, the result will be 200-100 = 100.

Answer 1

Just subtract them.

SELECT select nama_penerjemah, nama_projek, 
    SUM(bayaran) AS total_bayaran, SUM(denda) AS TOTAL_denda, 
    SUM(bayaran) - SUM(denda) AS total_difference
FROM tbl_episode 
GROUP BY nama_penerjemah, nama_projek