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);