select
    p.PF_CODE AS '都道府県コード',
    p.PF_NAME AS '都道府県名',
    ROUND(
        CAST(h.INP_YES as REAL)/CAST((h.INP_YES+h.INP_NO+h.UNIDENTIFIED)as REAL)*100 
    ,1) AS '入院率'
from
    PREFECTURE p,
    HOSPITALIZATION h
where 1=1
    and p.PF_CODE = h.PF_CODE
order by 入院率 desc,p.PF_CODE ASC