2
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 ) as "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:
https://www.urionlinejudge.com.br/judge/pt/problems/view/2738
which build error? face can already say that alias with simple quote will give error even (in 'name')
– Lucas Miranda
I can’t tell because it’s a problem I’m solving on Ri and I don’t have this database installed on my pc
– Beginner Programmer
And "name" didn’t work either :(
– Beginner Programmer
select can.name as 'name', ... Must be "name" with double quotes. It is not a string but an identifier, see Quoted.
– anonimo