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
You must log in or register to comment.