select c.name,round((s.math*2+s.specific*3+s.project_plan*5)/10,2) as avg
from candidate as c
inner join score as s on c.id=s.candidate_id
order by avg desc;
from candidate as c
inner join score as s on c.id=s.candidate_id
order by avg desc;
URI SQL Solution 2738 - Contest
I am Md Abdullah Al Hasan. I have completed my graduation in Computer Science and Engineering from Jashore University of Science and Technology.
0 Comments:
Post a Comment