Схема: workers (id, name), jobs (id, worker_id, start_date, status).
Выведи имена всех исполнителей, которые завершили (status = 'COMPLETED') больше 5 заданий.
1CREATE TABLE workers (id int PRIMARY KEY, name text NOT NULL);2CREATE TABLE jobs (3 id int PRIMARY KEY,4 worker_id int NOT NULL REFERENCES workers (id),5 start_date date NOT NULL,6 status text NOT NULL7);8INSERT INTO workers VALUES (1, 'Алексей'), (2, 'Борис'), (3, 'Виктор'), (4, 'Галина');9-- Алексей: 6 COMPLETED; Борис: ровно 5 COMPLETED; Виктор: 3 COMPLETED + 4 FAILED; Галина: 8 COMPLETED10INSERT INTO jobs11SELECT row_number() OVER (), w, date '2024-01-01' + n, s12FROM (VALUES (1, 6, 'COMPLETED'), (2, 5, 'COMPLETED'), (3, 3, 'COMPLETED'), (3, 4, 'FAILED'),13 (4, 8, 'COMPLETED')) AS v(w, cnt, s),14 generate_series(1, v.cnt) AS n;