Help with AVG query

[Reynier Perez Mira]

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