+ 2

# "Player_name" - bag

Помогите, пожалуйста, решить задачу по теннисному турниру в дата программинг

22nd Sep 2023, 2:32 PM
Anna
+ 2
-- выбрать имена игроков и общее количество очков как Total SELECT player_name, set_1+set_2+set_3 as Total from
23rd Sep 2023, 1:31 AM
Anna
+ 2
what is the name of the table?
23rd Sep 2023, 4:10 AM
Aaron Lee
+ 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.
23rd Sep 2023, 3:23 PM
Aaron Lee
+ 1
The table name is 'matches'. The full query is: SELECT player_name, set_1+set_2+set_3 as Total from matches
8th Nov 2023, 10:41 PM
Aneta Kahleová
0
Can you post the code so we can see?
22nd Sep 2023, 7:35 PM
Aaron Lee
0
There is no table name in the task conditions
23rd Sep 2023, 2:03 PM
Anna