This is an automated archive.

The original was posted on /r/mysql by /u/parodix2000 on 2023-11-30 03:36:21+00:00.


Hello everyone, I have a simple table where store runner who can run Saturday (name of column) and also Sunday (name of other column). Id is unique and the fields report X if people run. For final classification i need new table with nation of runner (another field) and the count SUM of people for each day have run.

Something like

Nation—SUM(Saturday)—SUM(Sunday)—SUM(total)

How can i do it? Many thanks