Top countries customers
SQL query for IFS ERP
List the top 5 countries with the most number of customers in the customer_entity_info table.
SELECT country, COUNT(*) as total_customers FROM customer_entity_info GROUP BY country ORDER BY total_customers DESC LIMIT 5
IFS ERP data model
Customer Entity Info
Iso Country Entityset
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed