Olá pessoal. Alguém poderia me ajudar no código? Me dá RUNTIME ERROR. Obrigado pela força :)

select final.name as name, final.nota_final as avg
from (select c.name as name, avg(((s.math*2) + (s.specific*3) + (project_plan*5))/10) as nota_final
      from candidate c
      inner join score as s on c.id = s.candidate_id) as final
order by 2