select 
pf.PF_CODE as '都道府県コード'
,pf.PF_NAME as '都道府県名'
,sub.INP_PROBABILITY as '入院率'
from
prefecture pf
join
(
select 
PF_CODE,
round((cast(hp.INP_YES as real) / (hp.INP_YES + hp.INP_NO + hp.UNIDENTIFIED))*100, 1) as INP_PROBABILITY
from
HOSPITALIZATION hp
) sub
on sub.PF_CODE = pf.PF_CODE
order by 
    sub.INP_PROBABILITY desc
    ,CAST(pf.PF_CODE as INTEGER) asc;