SELECT SUM(hommes+femmes) FROM population;

SELECT nom FROM departement,population 
WHERE departement.numero=population.numero
ORDER BY (hommes+femmes) DESC
LIMIT 1;


SELECT nom,(hommes+femmes) FROM departement,population 
WHERE departement.numero=population.numero
ORDER BY (hommes+femmes) 
LIMIT 10;


SELECT nom,(femmes/(hommes+femmes)) FROM departement,population 
WHERE departement.numero=population.numero
ORDER BY (femmes/(hommes+femmes)) DESC 
LIMIT 10;

SELECT nom FROM departement,population 
WHERE departement.numero=population.numero
AND (hommes+femmes) = (SELECT max(hommes+femmes) FROM population);

SELECT nom,(hommes+femmes) FROM departement,population 
WHERE departement.numero=population.numero
AND (hommes+femmes) > (SELECT AVG(hommes+femmes) FROM population);