"Player_name" - bag | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

"Player_name" - bag

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

22nd Sep 2023, 2:32 PM
Anna
7 Answers
+ 3
-- выбрать имена игроков и общее количество очков как 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
Aaron Lee - avatar
+ 2
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á
Aneta Kahleová - avatar
+ 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
Aaron Lee - avatar
+ 1
What's that The answers is not correct SELECT players_name, set_1+set_2+set_3 as total from ......what?
21st Feb 2024, 2:28 PM
Badhane Juga
Badhane Juga - avatar
0
Can you post the code so we can see?
22nd Sep 2023, 7:35 PM
Aaron Lee
Aaron Lee - avatar
0
There is no table name in the task conditions
23rd Sep 2023, 2:03 PM
Anna