--select *
--from HOSPITALIZATION;
--from PREFECTURE;

select
    a.PF_CODE as 都道府県コード,
    a.PF_NAME as 都道府県名,
    cast(round((cast(INP_YES as real)/cast(UNIDENTIFIED+INP_YES+INP_NO as real))*100,1) as int) as 入院率
    --(INP_YES/(UNIDENTIFIED+INP_YES+INP_NO))*100 as 入院率
from PREFECTURE a
inner join HOSPITALIZATION b on a.PF_CODE=b.PF_CODE;