SQL
SELECT
p.categoria,
c.pais,
COUNT() AS total_productos
FROM
productos p
JOIN
categorias c ON p.id_categoria = c.id
WHERE
p.precio > 100
GROUP BY
p.categoria,
c.pais
HAVING
COUNT() > 5
ORDER BY
total_productos DESC;
SELECT p.categoria, c.pais, COUNT(*) AS total_productos
FROM productos p
JOIN categorias c ON p.id_categoria = c.id
WHERE p.precio > 100
GROUP BY p.categoria, c.pais
HAVING COUNT(*) > 5
ORDER BY total_productos DESC
