Heres the solution for: URI Online Judge SQL Problem no. 2738-Contest

Displayt the candidate list, containing the name and final score (with two decimal places of precision) of each candidate. Remember to show the list ordered by score (highest first).

Detailed problem description

Output Sample

name                       |    avg
---------------------------------------------------
Edward C Durgan            |    74.10  
Timothy K Fitzsimmons      |    70.30  
Donna D Pursley            |    58.90  
Sheila R Denis             |    47.00  
Michael P Cannon           |    43.10 
Ivory B Morrison           |   35.90
. . . . . . . . . .        |   . . . 
. . . . . . . . . .        |   . . .