WITH MAX_DATE AS
(SELECT MEMBER_CODE,MAX(CHECKUP_DATE) AS CHK_DATE
  FROM HEALTH_CHECKUP
 GROUP BY MEMBER_CODE
),
MIN_DATE AS (
SELECT MEMBER_CODE,MIN(CHECKUP_DATE) AS CHK_DATE
  FROM HEALTH_CHECKUP
 GROUP BY MEMBER_CODE
),
MAX_DATA AS (
SELECT MC.CHECKUP_DATE,MC.MEMBER_CODE,MC.WEIGHT
  FROM HEALTH_CHECKUP MC INNER JOIN MAX_DATE MD
                            ON MC.MEMBER_CODE = MD.MEMBER_CODE
                           AND MC.CHECKUP_DATE = MD.CHK_DATE
),
MIN_DATA AS (
SELECT MC.CHECKUP_DATE,MC.MEMBER_CODE,MC.WEIGHT
  FROM HEALTH_CHECKUP MC INNER JOIN MIN_DATE MD
                            ON MC.MEMBER_CODE = MD.MEMBER_CODE
                           AND MC.CHECKUP_DATE = MD.CHK_DATE
)
SELECT AD.CHECKUP_DATE AS CK_DATE,
       AD.MEMBER_CODE AS CODE, 
       (MM.LAST_NAME || MM.FIRST_NAME) AS NAME,
       ROUND(CAST(AD.WEIGHT as real)  -  CAST(ID.WEIGHT as real),1) AS CHG_WT
  FROM MAX_DATA AD INNER JOIN MIN_DATA ID
                      ON AD.MEMBER_CODE = ID.MEMBER_CODE
                   INNER JOIN MEMBER_MST MM
                      ON AD.MEMBER_CODE = MM.MEMBER_CODE
 WHERE ABS(ROUND(CAST(AD.WEIGHT as real)  -  CAST(ID.WEIGHT as real),1)) >= 5
 ORDER BY CHG_WT DESC ,CODE DESC