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