问SQL如何获取按职位过滤的用户和部门列表？

EN

CREATE TABLE COMPANY 
(
    ID INT GENERATED BY DEFAULT AS IDENTITY,
    NAME VARCHAR(255),
    PRIMARY KEY (ID),
    UNIQUE KEY COMPANY_NAME (NAME)
);

CREATE TABLE USER
(
    ID INT GENERATED BY DEFAULT AS IDENTITY,
    NAME VARCHAR(255),
    LASTNAME VARCHAR(255),
    DATE_OF_BIRTH DATE ,
    PRIMARY KEY (ID),
);

CREATE TABLE POSITION
(
    ID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    POSITION VARCHAR (50),
    USERID INT NOT NULL,
    PRIMARY KEY (ID),
    FOREIGN KEY (USERID) REFERENCES USER(ID)
);

CREATE TABLE DEPARTMENT
(
    ID INT GENERATED BY DEFAULT AS IDENTITY,
    USER_ID INT NOT NULL,
    COMPANY_ID INT NOT NULL,
    DEPARTMENT_CATEGORY VARCHAR(50),
    PRIMARY KEY (ID),
    FOREIGN KEY (USER_ID) REFERENCES USER(ID),
    FOREIGN KEY (COMPANY_ID) REFERENCES COMPANY(ID)
);

CREATE TABLE CATEGORY 
(
    ID INT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    NAME VARCHAR (50),
    PRIMARY KEY (ID)
);

CREATE TABLE DEPARTMENT_CATEGORY
(
     DEPARTMENT_ID INT NOT NULL,
     CATEGORY_ID INT NOT NULL,
     FOREIGN KEY (DEPARTMENT_ID) REFERENCES DEPARTMENT(ID),
     FOREIGN KEY (CATEGORY_ID) REFERENCES CATEGORY(ID)
);