Snippet

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;
dvdrentalpublic