+ 2
"Player_name" - bag
Помогите, пожалуйста, решить задачу по теннисному турниру в дата программинг
7 Respuestas
+ 3
-- выбрать имена игроков и общее количество очков как Total
SELECT player_name, set_1+set_2+set_3 as Total
from
+ 2
what is the name of the table?
+ 2
The table name is 'matches'. The full query is:
SELECT player_name, set_1+set_2+set_3 as Total
from matches
+ 1
Strange... Do you see 3 sections at the top of your screen? 
"Problem" "Code" and "Result". If you tap on "Problem" you should see the following:
You are organizing a tennis tournament with multiple matches. Each match consists of three sets, and players earn scores in each set.
-->You have the following matches table:
[table]-------------------------------------------------
-   player name    set_1    set_2    set_3
-
-   John Smith       6            6            7  
-   Michael Johns....
[end of table]----------------------------------
Write a query to select the players' names and the total points as a field called Total.
+ 1
What's that
The answers is not correct
SELECT players_name, set_1+set_2+set_3
as total from ......what?
0
Can you post the code so we can see?
0
There is no table name in the task conditions



