Tennis Tournament In SQP

Question

SELECT player_name, SUM(set_1 + set_2 + set_3) AS total
FROM matches
GROUP BY player_name
ORDER BY total

Whar's goes wrong in my code ?
Thanks

Answer 1

1. The expected output doesn't seem to be in any order, why use OTHER BY?
2. Do you really need SUM() function to make calculation across different field?

Review slide 2 in Data Types sub-module, and compare the difference how they make calculation than yours.

Answer 2

Thank you Wong Hei Ming