name word hit Bill performance 2 Anna performance 5 John performance 3 Bill java 0 Anna java 1 John java 3 Bill test 4 Anna test 5 John test 1
name sum(hit) words_count Bill 6 performance = 2 java = 0, test = 4 Anna 11 performance = 5 java = 1, test = 5 John 7 performance = 3 java = 3, test = 1
SELECT name, sum(hit) as points, GROUP_CONCAT(concat(word, '->'), concat(hit, ' ') separator ' ' ) as words FROM results GROUP BY name;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)