I have a query with a calculated value:
AY_score + CG_score + GR_score + GT_score as judges_score
Is it possible to use the judges_score value in the WHERE clause?
I just would like to filter to show results where judges_score > 0, but using:
WHERE judges_score > 0
Is giving me the error: Unknown column ‘judges_score’ in ‘where clause’.
EDIT - sorry - realised I could just use:
(AY_score + CG_score + GR_score + GT_score > 0)