select 
h.PF_CODE AS 都道府県コード
,p.PF_NAME AS 都道府県名
-- 都道府県毎の入院率 → 入院率
,round(INP_YES*100/(INP_YES+INP_NO+UNIDENTIFIED),2) AS 入院率
from HOSPITALIZATION h
inner join PREFECTURE p on h.PF_CODE=p.PF_CODE