select
P.PF_CODE as 都道府県コード
, P.PF_NAME as 都道府県名
, ROUND(CAST(H.INP_YES * 100 as REAL) / CAST(H.INP_YES + H.INP_NO + H.UNIDENTIFIED as REAL), 1) as 入院率
from PREFECTURE as P
join HOSPITALIZATION as H on H.PF_CODE = P.PF_CODE