SELECT
    tbl1.CK_DATE,
    tbl1.CODE,
    tbl1.NAME,
    ROUND(tbl1.HEIGHT - tbl2.HEIGHT,1) AS CHG_WT
FROM
    (
    SELECT
        *
    FROM (
        SELECT
            ROW_NUMBER() OVER(PARTITION BY h.MEMBER_CODE ORDER BY CHECKUP_DATE desc) as rownum,
            h.CHECKUP_DATE AS CK_DATE,
            h.MEMBER_CODE AS CODE,
            h.HEIGHT,
            m.LAST_NAME || m.FIRST_NAME AS NAME
        FROM HEALTH_CHECKUP h
         INNER JOIN MEMBER_MST m
          ON h.MEMBER_CODE = m.MEMBER_CODE
        ) tbl
    WHERE tbl.rownum =1
    ) tbl1
    ,
    (
SELECT
    *
FROM (
    SELECT
        ROW_NUMBER() OVER(PARTITION BY h.MEMBER_CODE ORDER BY CHECKUP_DATE desc) as rownum,
        h.CHECKUP_DATE AS CK_DATE,
        h.MEMBER_CODE AS CODE,
        h.HEIGHT,
        m.LAST_NAME || m.FIRST_NAME AS NAME
    FROM HEALTH_CHECKUP h
     INNER JOIN MEMBER_MST m
      ON h.MEMBER_CODE = m.MEMBER_CODE
    ) tbl
WHERE tbl.rownum =2
) tbl2
WHERE ROUND(tbl1.HEIGHT - tbl2.HEIGHT,1) <= -5
ORDER BY ROUND(tbl1.HEIGHT - tbl2.HEIGHT,1) desc,tbl1.CODE desc