0
Sql
Imagine i have a matrix with id, name, age, country and i want the average age of each country
4 Réponses
+ 3
SELECT country, AVG(age)
FROM matrix
GROUP BY country
or sth to this extent :)
+ 1
Are you asking for help? If so, post the code you have so far and indicate when you have an issue. We will help but we need to see what you have so far first
+ 1
SELECT country, AVG(age) AS avgerageAge
FROM myMatrix
GROUP BY country
0
Thnx guys i did it