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