Got a sketch request:
SELECT * FROM `stat` GROUP BY `geo` ORDER BY `good` DESC
It works correctly, I can not understand how you can group fields and understand at the same time to calculate the sum in this group.
That is, there are countries (geo) they have the conversion (good == 0 || 1) I need to output data like this example:
EN
(`geo`)
- 100
(total number of `good` geo 'EN')
US - 50
GB - 30