Sobes.tech
Intern — Middle

Number of users in each city

livecode

Task condition

Write an SQL query that returns the name of the city and the number of users registered in that city.

create table cities (
    id serial primary key,
    name text not null
);

insert into cities (name)
values
('Moscow'),
('Saint Petersburg'),
('Krasnodar');

create table users (
    id serial primary key,
    name text not null,
    city_id int not null references cities(id)
);

insert into users (name, city_id)
values
('Ivan', 1),
('Anna', 1),
('Olesya', 2);

-- the SELECT query should be here