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