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