/*
SELECT
    LINE_ID AS LINE
  , SEAT_NO AS SEAT_F
  , SEAT_NO AS SEAT_T
  , 
FROM
    HEALTH_CHECKUP AS A
    INNER JOIN MEMBER_MST AS B
    ON A.MEMBER_CODE = B.MEMBER_CODE
WHERE

ORDER BY
    LINE_ID DESC
  , SEAT_NO ASC
*/


SELECT
    A.MEMBER_CODE
  , A.WEIGHT
FROM
  HEALTH_CHECKUP AS A
  INNER JOIN (
      SELECT
        MAX(CHECKUP_DATE) AS MAX_CHECKUP_DATE
        , MEMBER_CODE
      FROM
        HEALTH_CHECKUP
      GROUP BY
        MEMBER_CODE
  ) AS B
  ON A.MEMBER_CODE = B.MEMBER_CODE
     A.CHECKUP_DATE = B.MAX_CHECKUP_DATE