Racing Simulator Database
Table " test
"
uname | pts | track
uname
- player name, pts
- number of points on the track
Request to withdraw top players:
SELECT uname, SUM(pts) AS S FROM test GROUP BY uname ORDER BY S DESC
The task is to find the number of tracks the player traveled and bring it to the top, i.e. count the number of lines from the track
where this uname
is found. Unfortunately in SQL
I’m a complete zero, I don’t even know which way to google. While I read about nested queries and have already read that they work very slowly ...