text to sql syntaxThu, 16 Feb 2023

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

Questions about programming?Chat with your personal AI assistant