Select count of all customers for every region including which region has the highest mobile users TABLE Customer customerID(INT), region(STRING), device(STRING) TABLE Visit customerID(INT), visit_id(STRING), visit_type(STRING), visit_duration(STRING), product(STRING), visit_value(INT)
SELECT COUNT(c.customerID), c.region, c.device FROM Customers c GROUP BY c.region, c.device ORDER BY COUNT(c.customerID) DESC