SELECT
    P.PF_CODE
    ,PF_NAME
    ,NATION_NAME
    ,AMT AS 人数
FROM
    FOREIGNER F
    INNER JOIN NATIONALITY N ON N.NATION_CODE = F.NATION_CODE
    INNER JOIN PREFECTURE P ON P.PF_CODE = F.PF_CODE
WHERE
    F.NATION_CODE <> '113'
GROUP BY
    P.PF_CODE, N.NATION_CODE
ORDER BY
    人数 DESC