Sobes.tech
Junior — Senior

Get a list of all cities with their number of users, including cities without users

livecode

Task condition

Display a list of all cities along with the number of users associated with them, including cities with no users.

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

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

-- Table "users"
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),
    ('Oleg', 2);