-- 姓の2文字目が'田'となっている会員データを表示
SELECT
    MEMBER_CODE AS CODE,
    LAST_NAME AS L_NAME,
    FIRST_NAME AS F_NAME
FROM
    MEMBER_MST
WHERE
    SUBSTRING(LAST_NAME, 2, 1) = '田'
ORDER BY
    MEMBER_CODE DESC;