# Вывести уникальный список городов
# Вывести количество сотрудников в городах
# Вывести только те города, в которых количество сотрудников больше 1

DROP TABLE IF EXISTS employee;
CREATE TABLE IF NOT EXISTS employee (name VARCHAR(30) PRIMARY KEY, city VARCHAR(50));
INSERT INTO employee VALUES
('Иванов', 'Москва'),
('Петров', 'Москва'),
('Сидоров', 'Воронеж');

table: transactions

id   shopId    amount    date
1    shop1     1000.00   2023.01.01 15:17:01
2    shop2      700.00   2023.01.01 15:13:02
3    shop2      330.00   2023.01.01 15:10:03
4....

List<String> list = new ArrayList<>();
list.add("milk");
list.add("bread");
list.add("sausage");
Stream<String> stream = list.stream();
list.add("eggs");
stream.forEach(System.out::println);

CREATE TABLE IF NOT EXISTS company (
id uuid PRIMARY KEY,
name_ varchar NOT NULL
);

CREATE TABLE IF NOT EXISTS department (
id uuid PRIMARY KEY,
name_ varchar NOT NULL,
company_id uuid NOT NULL,
CONSTRAINT department_fk FOREIGN KEY (company_id) REFERENCES company(id)
);

CREATE TABLE IF NOT EXISTS employee (
id uuid PRIMARY KEY,
name_ varchar NOT NULL,
department_id uuid NOT NULL,
CONSTRAINT employee_fk FOREIGN KEY (department_id) REFERENCES department(id)
);

INSERT INTO company (id, name_) VALUES (1, 'Company 1') ON CONFLICT DO NOTHING;
INSERT INTO company (id, name_) VALUES (2, 'Company 2') ON CONFLICT DO NOTHING;
INSERT INTO company (id, name_) VALUES (3, 'Company 3') ON CONFLICT DO NOTHING;

INSERT INTO department (id, name_, company_id) VALUES (1, 'Department 1', 1) ON CONFLICT DO NOTHING;
INSERT INTO department (id, name_, company_id) VALUES (2, 'Department 2', 1) ON CONFLICT DO NOTHING;
INSERT INTO department (id, name_, company_id) VALUES (3, 'Department 3', 2) ON CONFLICT DO NOTHING;

INSERT INTO employee (id, name_, department_id) VALUES (1, 'Employee 1', 1) ON CONFLICT DO NOTHING;
INSERT INTO employee (id, name_, department_id) VALUES (2, 'Employee 2', 1) ON CONFLICT DO NOTHING;
INSERT INTO employee (id, name_, department_id) VALUES (3, 'Employee 3', 3) ON CONFLICT DO NOTHING;

public class Operator {
private String id;
private String fio;
private List<Branch> branches;
}