In SQL, you can calculate an average of a column using the AVG function:

SELECT profession, AVG(salaire) AS salaire_moyen
FROM personnel
GROUP BY profession
LIMIT 0,5;

You can think of AVG(a) as SUM(a) / COUNT(a)