"Player_name" - bag | Sololearn: Learn to code for FREE!
Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula grƔtis
+ 2

"Player_name" - bag

ŠŸŠ¾Š¼Š¾Š³ŠøтŠµ, ŠæŠ¾Š¶Š°Š»ŃƒŠ¹ŃŃ‚Š°, рŠµŃˆŠøть Š·Š°Š“Š°Ń‡Ńƒ ŠæŠ¾ тŠµŠ½Š½ŠøсŠ½Š¾Š¼Ńƒ турŠ½Šøру Š² Š“Š°Ń‚Š° ŠæрŠ¾Š³Ń€Š°Š¼Š¼ŠøŠ½Š³

22nd Sep 2023, 2:32 PM
Anna
7 Respostas
+ 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