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
...