-- 1. Выведи ОТДЕЛ и МаксЗП
-- 2. Выведи ИМЯ И МаксЗП
 
CREATE TABLE IF NOT EXISTS departments (
   department_id integer PRIMARY KEY,
   name text NOT NULL
);
CREATE TABLE IF NOT EXISTS employees (
   employee_id integer PRIMARY KEY,
   department_id integer NOT NULL REFERENCES departments(department_id),
   name text NOT NULL,
   salary money NOT NULL
);
 
INSERT INTO departments (department_id, name) VALUES
    (1, 'Engineering'),
    (2, 'HR'),
    (3, 'Marketing')
ON CONFLICT (department_id) DO NOTHING;
 
INSERT INTO employees (employee_id, department_id, name, salary) VALUES
    (1, 1, 'Alice Johnson Engineering', '80000'),
    (2, 1, 'Bob Smith Engineering', '75000'),
    (3, 2, 'Charlie Brown HR', '60000'),
    (4, 2, 'Jack black HR', '62000'),
    (5, 3, 'David White Marketing', '65000'),
    (6, 3, 'Ivan Ivanov Marketing', '75000'),
    (7, 3, 'David Blain Marketing', '85000'),
    (8, 3, 'Arkadii Polyudov Marketing', '85000')
 
ON CONFLICT (employee_id) DO NOTHING;
 
SELECT * FROM employees

LS0gMS4g0JLRi9Cy0LXQtNC4INCe0KLQlNCV0Jsg0Lgg0JzQsNC60YHQl9CfCi0tIDIuINCS0YvQstC10LTQuCDQmNCc0K8g0Jgg0JzQsNC60YHQl9CfCgpDUkVBVEUgVEFCTEUgSUYgTk9UIEVYSVNUUyBkZXBhcnRtZW50cyAoCiAgIGRlcGFydG1lbnRfaWQgaW50ZWdlciBQUklNQVJZIEtFWSwKICAgbmFtZSB0ZXh0IE5PVCBOVUxMCik7CkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTIGVtcGxveWVlcyAoCiAgIGVtcGxveWVlX2lkIGludGVnZXIgUFJJTUFSWSBLRVksCiAgIGRlcGFydG1lbnRfaWQgaW50ZWdlciBOT1QgTlVMTCBSRUZFUkVOQ0VTIGRlcGFydG1lbnRzKGRlcGFydG1lbnRfaWQpLAogICBuYW1lIHRleHQgTk9UIE5VTEwsCiAgIHNhbGFyeSBtb25leSBOT1QgTlVMTAopOwoKSU5TRVJUIElOVE8gZGVwYXJ0bWVudHMgKGRlcGFydG1lbnRfaWQsIG5hbWUpIFZBTFVFUwogICAgKDEsICdFbmdpbmVlcmluZycpLAogICAgKDIsICdIUicpLAogICAgKDMsICdNYXJrZXRpbmcnKQpPTiBDT05GTElDVCAoZGVwYXJ0bWVudF9pZCkgRE8gTk9USElORzsKCklOU0VSVCBJTlRPIGVtcGxveWVlcyAoZW1wbG95ZWVfaWQsIGRlcGFydG1lbnRfaWQsIG5hbWUsIHNhbGFyeSkgVkFMVUVTCiAgICAoMSwgMSwgJ0FsaWNlIEpvaG5zb24gRW5naW5lZXJpbmcnLCAnODAwMDAnKSwKICAgICgyLCAxLCAnQm9iIFNtaXRoIEVuZ2luZWVyaW5nJywgJzc1MDAwJyksCiAgICAoMywgMiwgJ0NoYXJsaWUgQnJvd24gSFInLCAnNjAwMDAnKSwKICAgICg0LCAyLCAnSmFjayBibGFjayBIUicsICc2MjAwMCcpLAogICAgKDUsIDMsICdEYXZpZCBXaGl0ZSBNYXJrZXRpbmcnLCAnNjUwMDAnKSwKICAgICg2LCAzLCAnSXZhbiBJdmFub3YgTWFya2V0aW5nJywgJzc1MDAwJyksCiAgICAoNywgMywgJ0RhdmlkIEJsYWluIE1hcmtldGluZycsICc4NTAwMCcpLAogICAgKDgsIDMsICdBcmthZGlpIFBvbHl1ZG92IE1hcmtldGluZycsICc4NTAwMCcpCiAgICAKT04gQ09ORkxJQ1QgKGVtcGxveWVlX2lkKSBETyBOT1RISU5HOwoKU0VMRUNUICogRlJPTSBlbXBsb3llZXM=