WITH HEALTH AS (
     SELECT
          RANK() OVER(PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS SEQ
         ,CHECKUP_DATE
         ,MEMBER_CODE
         ,WEIGHT
     FROM HEALTH_CHECKUP
)
SELECT
     CUR.CHECKUP_DATE                AS CK_DATE
    ,CUR.MEMBER_CODE                 AS CODE
    ,MST.LAST_NAME || MST.FIRST_NAME AS NAME
    ,ROUND(CUR.WEIGHT - HIS.WEIGHT,2)         AS CHG_WT
FROM HEALTH AS CUR
     INNER JOIN MEMBER_MST AS MST
         ON CUR.MEMBER_CODE = MST.MEMBER_CODE
     INNER JOIN HEALTH AS HIS
         ON CUR.MEMBER_CODE = HIS.MEMBER_CODE
        AND CUR.SEQ = HIS.SEQ - 1
        AND CUR.SEQ < HIS.SEQ
WHERE ABS(ROUND(CUR.WEIGHT - HIS.WEIGHT,2)) >= 5
ORDER BY CHG_WT DESC, CUR.MEMBER_CODE DESC
;