I now have a list of the above, could you tell me how to generate the following summary table type?

CodePudding user response:

The select leiname, sum (` count `) as the count from table group by leiname