Elasticsearch, with the SQL it's missing.
SELECT o.country, COUNT(*) AS orgs
FROM organizations o
JOIN suppliers s ON s.domain = o.primary_domain
GROUP BY o.country
QUALIFY ROW_NUMBER() OVER (ORDER BY orgs DESC) <= 3;
3 rows · pushed down: WHERE, GROUP BY, join keys · 1.2s
Not affiliated with Elastic N.V. or the OpenSearch Project.