select  HP.PF_CODE as 都道府県コード,PF.PF_NAME as 都道府県名,
round (cast(HP.INP_YES)/cast(HP.INP_YES + HP.INP_NO+HP.UNIDENTIFIED)) as 入院率
FROM
    HOSPITALIZATION AS HP 
    INNER JOIN PREFECTURE AS PF 
        ON PF.PF_CODE = HP.PF_CODE