 查一下患者朱高翰在医院2154200中从二零年一月二十五日到二一年九月十五日的这段时间里开的所有的药和药品编码
CREATE TABLE t_kc22 (
    MED_EXP_DET_ID text,
    OVERALL_CD_ORG text,
    OVERALL_CD_PERSON text,
    MED_CLINIC_ID text,
    MED_EXP_BILL_ID text,
    SOC_SRT_DIRE_CD text,
    SOC_SRT_DIRE_NM text,
    DIRE_TYPE number,
    CHA_ITEM_LEV number,
    MED_INV_ITEM_TYPE text,
    MED_DIRE_CD text,
    MED_DIRE_NM text,
    VAL_UNIT text,
    DOSE_UNIT text,
    DOSE_FORM text,
    SPEC text,
    USE_FRE text,
    EACH_DOSAGE text,
    QTY number,
    UNIVALENT number,
    AMOUNT number,
    SELF_PAY_PRO number,
    RER_SOL number,
    SELF_PAY_AMO number,
    UP_LIMIT_AMO number,
    OVE_SELF_AMO number,
    EXP_OCC_DATE time,
    RECIPE_BILL_ID text,
    FLX_MED_ORG_ID text,
    MED_ORG_DEPT_CD text,
    MED_ORG_DEPT_NM text,
    HOSP_DOC_CD text,
    HOSP_DOC_NM text,
    REF_STA_FLG number,
    DATA_ID text,
    SYNC_TIME time,
    PRESCRIPTION_CODE text,
    PRESCRIPTION_ID text,
    TRADE_TYPE number,
    STA_FLG number,
    STA_DATE time,
    REIMBURS_TYPE number,
    FXBZ number,
    REMOTE_SETTLE_FLG text
)

CREATE TABLE t_kc21 (
    MED_CLINIC_ID text,
    OVERALL_CD_ORG text,
    OVERALL_CD_PERSON text,
    COMP_ID text,
    PERSON_ID text,
    PERSON_NM text,
    IDENTITY_CARD text,
    SOC_SRT_CARD text,
    PERSON_SEX number,
    PERSON_AGE number,
    IN_HOSP_DATE time,
    OUT_HOSP_DATE time,
    DIFF_PLACE_FLG number,
    FLX_MED_ORG_ID text,
    MED_SER_ORG_NO text,
    CLINIC_TYPE text,
    MED_TYPE number,
    CLINIC_ID text,
    IN_DIAG_DIS_CD text,
    IN_DIAG_DIS_NM text,
    OUT_DIAG_DIS_CD text,
    OUT_DIAG_DIS_NM text,
    INPT_AREA_BED text,
    MED_ORG_DEPT_CD text,
    MED_ORG_DEPT_NM text,
    OUT_DIAG_DOC_CD text,
    OUT_DIAG_DOC_NM text,
    MAIN_COND_DES text,
    INSU_TYPE text,
    IN_HOSP_DAYS number,
    MED_AMOUT number,
    FERTILITY_STS number,
    DATA_ID text,
    SYNC_TIME time,
    REIMBURSEMENT_FLG number,
    HOSP_LEV number,
    HOSP_STS number,
    INSURED_IDENTITY number,
    SERVANT_FLG text,
    TRADE_TYPE number,
    INSURED_STS text,
    REMOTE_SETTLE_FLG text
)

CREATE TABLE t_kc24 (
    MED_SAFE_PAY_ID text,
    OVERALL_CD_ORG text,
    OVERALL_CD_PERSON text,
    MED_CLINIC_ID text,
    REF_SLT_FLG number,
    CLINIC_SLT_DATE time,
    COMP_ID text,
    PERSON_ID text,
    FLX_MED_ORG_ID text,
    INSU_TYPE text,
    MED_AMOUT number,
    PER_ACC_PAY number,
    OVE_PAY number,
    ILL_PAY number,
    CIVIL_SUBSIDY number,
    PER_SOL number,
    PER_EXP number,
    DATA_ID text,
    SYNC_TIME time,
    OUT_HOSP_DATE time,
    CLINIC_ID text,
    MED_TYPE number,
    INSURED_STS text,
    INSURED_IDENTITY number,
    TRADE_TYPE number,
    RECIPE_BILL_ID text,
    ACCOUNT_DASH_DATE time,
    ACCOUNT_DASH_FLG number,
    REIMBURS_FLG number,
    SENDER_DEAL_ID text,
    RECEIVER_DEAL_ID text,
    SENDER_REVOKE_ID text,
    RECEIVER_REVOKE_ID text,
    SENDER_OFFSET_ID text,
    RECEIVER_OFFSET_ID text,
    LAS_OVE_PAY number,
    OVE_ADD_PAY number,
    SUP_ADD_PAY number,
    CKC102 number,
    CASH_PAY number,
    COM_ACC_PAY number,
    ENT_ACC_PAY number,
    ENT_PAY number,
    COM_PAY number,
    OLDC_FUND_PAY number,
    SPE_FUND_PAY number
)
SELECT SOC_SRT_DIRE_CD, SOC_SRT_DIRE_NM FROM t_kc22 WHERE MED_CLINIC_ID IN (SELECT MED_CLINIC_ID FROM t_kc21 WHERE PERSON_NM = '朱高翰' AND MED_SER_ORG_NO = '2154200' AND IN_HOSP_DATE BETWEEN '2020-01-25' AND '2021-09-15')