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