在mysql中多次求和

Question

I have a table structure like this:

-----------------------------
|Branch   |Cluster   |Point |
-----------------------------
|branch a |Cluster 1 |1000  |
-----------------------------
|branch a |Cluster 2 |2000  |
-----------------------------
|branch b |Cluster 3 |1000  |
-----------------------------
|branch b |Cluster 4 |1000  |
-----------------------------

I would like to select the total of each branch. So my output would be like

-----------------------------
|Branch   |Cluster   |Point |
-----------------------------
|branch a |Cluster 1 |1000  |
-----------------------------
|branch a |Cluster 2 |2000  |
-----------------------------
|Total branch a      |3000  |
-----------------------------
|branch b |Cluster 4 |1000  |
-----------------------------
|branch b |Cluster 3 |1000  |
-----------------------------
|Total branch b      |2000  |
-----------------------------

Answer 1

(
    SELECT Branch, Cluster, Point
    FROM yourTable
)
UNION ALL
(
    SELECT Branch, 'Total' AS Cluster, SUM(Point) AS Point
    FROM yourTable
    GROUP BY Branch
)
ORDER BY Branch, Cluster

This assumes that all the data in the Cluster column really begins with the letter 'C'.