0

Sql

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

19th May 2020, 7:20 PM
Jason Papastavrou
Jason Papastavrou - avatar
4 Réponses
+ 3
SELECT country, AVG(age) FROM matrix GROUP BY country or sth to this extent :)
19th May 2020, 7:25 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
+ 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
19th May 2020, 7:25 PM
Elizabeth Kelly
Elizabeth Kelly - avatar
+ 1
SELECT country, AVG(age) AS avgerageAge FROM myMatrix GROUP BY country
19th May 2020, 7:25 PM
Manu_1-9-8-5
Manu_1-9-8-5 - avatar
0
Thnx guys i did it
19th May 2020, 7:27 PM
Jason Papastavrou
Jason Papastavrou - avatar