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