1. Los países más grandes del mundo
SELECT code AS codigo, name AS "nombre", surfacearea AS "area" FROM country WHERE surfacearea > (SELECT AVG (surfacearea )FROM country ) ORDER BY surfacearea DESC En total salieron 43 países mas grandes del mundo
2 .Los 10 países más grandes del mundo
SELECT code AS codigo, name AS "nombre", surfacearea AS "area" FROM country WHERE surfacearea > (SELECT AVG (surfacearea )FROM country ) ORDER BY surfacearea DESC LIMIT 10;
3. Los 10 países más ricos del mundo
SELECT code AS codigo, name AS "nombre", surfacearea AS "area",gnp AS "pruducto interno bruto" FROM country WHERE gnp > (SELECT AVG ( gnp )FROM country ) ORDER BY gnp DESC LIMIT 10
4. Los 10 países más ricos con el PIB per Cápita
SELECT code AS codigo, name AS "nombre",gnp AS "pruducto interno bruto",population, (SELECT gnp/population) AS "países más ricos con el PIB per Cápita" FROM country WHERE population > 0 ORDER BY 4 DESC LIMIT 10
5.
Los 5 países con mayor expectativa de vida
SELECT code AS codigo, name AS "nombre",lifeexpectancy AS "países con mayor expectativa de vida" FROM country WHERE lifeexpectancy > 0 ORDER BY lifeexpectancy DESC LIMIT 5
6 .El PIB de cada continente
SELECT code AS codigo, name AS "nombre", continent, gnp AS "pruducto interno bruto actual ",gnpold AS "pib antiguo" FROM country WHERE (gnp>0) AND (gnpold>0) ORDER BY continent El total de 178 resultados el PIB de cada continente
7. Los 10 países más pequeños del mundo SELECT code AS codigo, name AS "nombre", surfacearea AS "area" FROM country WHERE surfacearea < (SELECT AVG (surfacearea )FROM country ) LIMIT 10;
8
Los países más grandes del mundo con nombre de 6 letras
SELECT code AS codigo, name AS "nombre", surfacearea AS "area" FROM country WHERE surfacearea > (SELECT AVG (surfacearea )FROM country )
AND name LIKE '______'//// con esta __ sacar determinados letras que necesita
9
El país más rico en cada continente SELECT name AS "nombre",continent AS continente , surfacearea AS "area",gnp AS "pruducto interno bruto" FROM country WHERE gnp in (SELECT MAX ( gnp )FROM country WHERE gnp >0 group by continent order by 1) order by 3 desc
10 El país más pobre de cada continente
11
11 El país más chico de cada continente SELECT name AS "nombre",continent AS continente , surfacearea AS "area",gnp AS "pruducto interno bruto" FROM country WHERE surfacearea in (SELECT MIN ( surfacearea )FROM country group by continent order by 1) order by 3 desc
SELECT name AS "nombre",continent AS continente , surfacearea AS "area",gnp AS "pruducto interno bruto" FROM country WHERE surfacearea in (SELECT MAX ( surfacearea )FROM country group by continent order by 1) order by 3 desc 12 El país más grande de cada continente 13
13 Los países con mejor expectativa de vida independizados en el siglo 20 SELECT code as codigo, name as nombre_pais , continent as continente ,indepyear AS AÑO , lifeexpectancy as expectativa_vida FROM public.country WHERE lifeexpectancy > (SELECT MAX ( lifeexpectancy )FROM country ) ORDER BY lifeexpectancy SELECT code as codigo, name as nombre_pais , continent as continente ,indepyear AS AÑO , lifeexpectancy as expectativa_vida FROM public.country WHERE lifeexpectancy > (SELECT MAX ( lifeexpectancy )FROM country WHERE lifeexpectancy >0 AND indepyear BETWEEN 1900 AND 1994 ) ORDER BY lifeexpectancy