Tennis Tournament what I am missing?

Question

I wrote a query and according to the test, its bringing the results desired by not in the order test as expecting, the weird thing is that the expected result are not ordered at all.

-- select players` names and the total points as Total
SELECT player_name, SUM(set_1 + set_2 + set_3) as total
FROM matches
GROUP BY player_name

Answer 1

Check the description of the task again, read carefully and understand.

Hints:

• what are the query requirements & does it asks you to include "GROUP BY" clause for solving query?
• Does the task ask you aggregating the total using "SUM()" function?
• Your query asks to add total points aliasing it "AS Total."

Answer 2

• It's conventional to make all SQL statements uppercased and from the comments it should be "Total" not "total" so correct thing is "AS Total".

• Since you're talking about sorting here or ordering the right statement to use is "ORDER BY" not "GROUP BY" cause each player has a distinct name so you can't group them by names.

Answer 3

if someone completes this code and writes to me, thank you

Answer 4

SELECT player_name, SUM(set_1, set_2, set_3) as total
FROM matches
ORDER BY player_name

Answer 5

it doesn't give input I tried this before thanks my friend

Answer 6

SELECT player_name, set_1 + set_2 + set_3 AS total FROM matches

Answer 7

thanks don't working

Answer 8

SELECT player_name , set_1 + set_2 + set_3 AS Total
FROM matches
this is the solution

Answer 9

hey guys Online Bookstore sql
SELECT *
FROM books
WHERE author = 'Fiction'
what's wrong

Answer 10

If you look closely you will see the order of names in the table is the same as the result order, which suggest you don’t need to specific the ordering on the result.
You are very close to pass the test, give it another try.

Answer 11

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

the order for the output is wrong i am not sure what is wrong

player_name,total
Sophia Davis,18
John Smith,19
Michael Johnson,16
Emily Thompson,20
Daniel Wilson,16

the actual output
player_name,total
John Smith,19
Michael Johnson,16
Emily Thompson,20
Daniel Wilson,16
Sophia Davis,18

Answer 12

AMIR H R A<ヾ(@^▽^@)ノ >LION 💪
It is a different question.
Please open a new post, or use the search function first.

Answer 13

This is the correct code:-

-- select players` names and the total points as Total
SELECT player_name, CONCAT(set_1 + set_2 + set_3) as total
FROM matches

Answer 14

-- select players` names and the total points as Total
Select player_name , (set_1+ set_2+set_3) as total
FROM matches