I'm trying to run this query in postgresql but it gives compilation error:
select can.name as 'name', ((sco.math 2) + (sco.specific1 3) + (sco.project_plan * 5)) / 10) the "avg" from candidate can join score sco on can.id = sco.candidate_id order by "avg" desc;
The problem is described in the link below: