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

order by 入院率 desc

;