Hi every:
I have this table:
smp_evaluacion
---------------
id_evaluacion
eval1
eval2
eval3
eval4
eval5
This is for a rating system. I need to build a query for retrieve the best
rating files. Normally with PHP I add every field, I mean (eval1, eval2, eval3,
eval4, eval5) and then divide this result by 5, like a average. I know that SQL
can do this directly using AVG function but I don't know how. Can any help me?
Cheers and thanks in advance
Reynier Pérez Mira
5to. año Ing. Informática
Universidad de las Ciencias Informáticas