Score as Percentage of the Best
Medium
Derived Tables
Return each student's score as a percentage of the highest score, rounded to 2 decimals, ordered by score descending.
Table schema
Scores(name VARCHAR(10), score INT)Sample data
name | score
Ann | 80
Bob | 60
Cy | 40
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.