WITH s AS(
    SELECT
        MEMBER_CODE,
        CHECKUP_DATE,
        rank() over (
            PARTITION by MEMBER_CODE
            ORDER BY
                CHECKUP_DATE desc
        ) AS srank,
        WEIGHT
    FROM
        HEALTH_CHECKUP
),
sstop AS (
    SELECT
        *
    FROM
        s
    WHERE
        srank = 1
),
sec AS(
    SELECT
        *
    FROM
        s
    WHERE
        srank = 2
),
res AS (
    SELECT
        sstop.MEMBER_CODE,
        sstop.CHECKUP_DATE AS d,
        round(sstop.WEIGHT - sec.WEIGHT, 1) AS w
    FROM
        sstop
        INNER JOIN sec on sstop.MEMBER_CODE = sec.MEMBER_CODE
    WHERE
        abs(round(sstop.WEIGHT - sec.WEIGHT, 1)) >= 5.0
)
SELECT
    d AS 'CK_DATE',
    res.MEMBER_CODE AS 'CODE',
    LAST_NAME || FIRST_NAME AS 'NAME',
    w AS 'CHG_WT'
FROM
    res
    INNER JOIN MEMBER_MST ON res.MEMBER_CODE = MEMBER_MST.MEMBER_CODE
ORDER BY
    CHG_WT DESC,
    res.MEMBER_CODE DESC