Let's say I have a table like this to make things simple:
I want to combine the data for bob and steve into just steve. What SQL code would I use to merge bob and steve together per blockID, and for Destroyed and Placed, end up with the sum of of them added together?
Code:
UUID blockID Destroyed Placed bob 1 107 627 steve 1 1560 97 joe 1 136 11 bob 2 1294 741 steve 2 8121 4465 joe 2 0 51 bob 3 138 443 steve 3 2475 1783 joe 3 50 89 bob 4 2 2 steve 4 4 35 joe 4 1 5
Comment