W3School TIY Editor

SELECT COUNT(customer_id), country FROM customers GROUP BY country;