+ 2
"Player_name" - bag
Помогите, пожалуйста, решить задачу по теннисному турниру в дата программинг
7 odpowiedzi
+ 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