Sql

Question

Imagine i have a matrix with id, name, age, country and i want the average age of each country

Answer 1

SELECT country, AVG(age)
FROM matrix
GROUP BY country

or sth to this extent :)

Answer 2

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

Answer 3

SELECT country, AVG(age) AS avgerageAge
FROM myMatrix
GROUP BY country

Answer 4

Thnx guys i did it