WITH LATEST AS (
    SELECT
        MEMBER_CODE,
        MAX(CHECKUP_DATE) AS LATEST
    FROM HEALTH_CHECKUP
    GROUP BY MEMBER_CODE
), SECOND AS (
    SELECT
        HC.MEMBER_CODE,
        MAX(CHECKUP_DATE) AS SECOND
    FROM HEALTH_CHECKUP AS HC, LATEST AS L
    WHERE HC.CHECKUP_DATE != L.LATEST AND HC.MEMBER_CODE = L.MEMBER_CODE
    GROUP BY HC.MEMBER_CODE
), WEIGHT_CHANGE AS (
    SELECT
        L.LATEST AS CK_DATE,
        HC1.MEMBER_CODE AS CODE,
        ROUND(HC1.WEIGHT - HC2.WEIGHT, 2) AS CHG_WT
    FROM LATEST AS L, SECOND AS S,
    HEALTH_CHECKUP AS HC1 LEFT JOIN HEALTH_CHECKUP AS HC2 ON HC1.MEMBER_CODE = HC2.MEMBER_CODE
    WHERE HC1.MEMBER_CODE = L.MEMBER_CODE AND HC1.MEMBER_CODE = S.MEMBER_CODE
    AND HC1.CHECKUP_DATE = L.LATEST AND HC2.CHECKUP_DATE = S.SECOND
    AND ABS(CHG_WT) >= 5
)
SELECT WC.CK_DATE, WC.CODE, MM.LAST_NAME || MM.FIRST_NAME AS NAME, WC.CHG_WT FROM WEIGHT_CHANGE AS WC, MEMBER_MST AS MM
WHERE WC.CODE = MM.MEMBER_CODE
ORDER BY CHG_WT DESC, CODE DESC