SQLAI.ai

which is the most common city for customers

            
SELECT city, COUNT(*) AS num_customers FROM customer_list GROUP BY city ORDER BY num_customers DESC LIMIT 1;
  • Public
  • ·
  • Thu, 02 Mar 2023 18:44:11 GMT