Sobes.tech
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);