Sobes.tech
Intern — Senior

Cities where the number of clients exceeds a thousand

livecode

Task condition

The table contains about a million records. It is necessary to determine in which cities the number of clients exceeds 1000, and to output the names of these cities.

CREATE TABLE customers (
    id INT AUTO_INCREMENT,
    email VARCHAR(256) NOT NULL,
    city VARCHAR(100) NOT NULL
);

Sample data:

1, a@mail.com, Voronezh  
2, b@mail.com, NY  
3, c@mail.com, Voronezh  
4, d@mail.com, Voronezh  
...