Sum of a total amount where case is coming in

Question

I come across this beautiful link - How can I return pivot table output in MySQL?

Which solves my exact problem. However, I need one of the columns as sum of the value - which is an amount column

How to add a sum of a column in the query. Please advise.

Answer 1

Try this query:

SELECT SUM(column_name)
FROM table_name
WHERE condition;