Intern — Senior
Get city names along with the names of their inhabitants
livecode
Task condition
You need to create an SQL query that outputs the names of cities and the names of users living in those cities.
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),
('Oleg',2);