Your search query "linkto:"FLISOL2006/Ayudar/SistemaRegistro/Consultas"" didn't return any results. Please change some terms and refer to HelpOnSearching for more information.
(!) Consider performing a full-text search with your search terms.

Clear message

Locked History Actions

FLISOL2006/Ayudar/SistemaRegistro/Consultas

-- Cantidad de departamentos por país

SELECT count(d.id) AS deptos,p.nombre FROM departamentos d, paises p WHERE d.pais=p.id GROUP BY pais,p.nombre ORDER BY deptos DESC,p.nombre;

-- Cantidad de ciudades por país

SELECT count(c.id) AS cciudades,p.nombre FROM departamentos d, paises p, ciudades c WHERE d.pais=p.id AND c.departamento=d.id GROUP BY p.nombre ORDER BY cciudades DESC,p.nombre;