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