+ 2

Coding foundation- Tennis Tournament

Hello, could anyone help me with this SQL code? It's one of my first approaches to SQL coding and I'm a bit confused https://sololearn.com/coach/1272182164/?ref=app

2nd Sep 2023, 5:54 PM
Rossella Solaro
Rossella Solaro - avatar
3 Respuestas
+ 6
For each player, you should add the values in the columns set_1 set_2 and set_3 and put them in a column that is called Total.
2nd Sep 2023, 8:14 PM
Paul
Paul - avatar
0
#was also stuck SELECT player_name, set_1+set_2+set_3 AS Total FROM matches --this_worked_for_me--
7th Oct 2023, 6:03 AM
Marcus Mwaba Banda
Marcus Mwaba Banda - avatar
0
Solved it for you SELECT player_name, set_1 + set_2+ set_3 As total from matches
5th Mar 2025, 12:42 PM
Christian Francis
Christian Francis - avatar