SELECT
    A.PF_CODE AS 都道府県コード,
    B.PF_NAME AS  都道府県名,
    ROUND((A.INP_YES * 100.0)/(A.INP_YES + A.INP_NO + A.UNIDENTIFIED), 1) AS 入院率
FROM HOSPITALIZATION AS A
    INNER JOIN PREFECTURE AS B
    ON A.PF_CODE = B.PF_CODE
ORDER BY 入院率 DESC, 都道府県コード ASC;