select
    t1.PF_CODE as 都道府県コード
    , t2.PF_NAME as 都道府県名
    , ROUND(( cast(INP_YES as REAL) / (cast(INP_YES as REAL) + cast(INP_NO as REAL) + cast(UNIDENTIFIED as REAL))) * 100,2 )
from HOSPITALIZATION as t1
left join PREFECTURE as t2
    using(PF_CODE)
group by 1,2,3
order by 1