SELECT region.name AS region, COUNT(*) AS nation_count FROM nation JOIN region ON nation.regionkey = region.regionkey GROUP BY region.name ORDER BY nation_count DESC;
Presto requires Java 11 or higher to run. You can install OpenJDK 11 using the following commands: como instalar presto 8.8 tutorial
Presto necesita al menos un catálogo para ejecutar consultas. Usaremos el conector memory para pruebas rápidas. SELECT region
Presto requires Java 11 or 17.
[Install] WantedBy=multi-user.target