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
HOSPITALIZATION as H
inner join 
PREFECTURE as P
on H.PF_CODE = P.PF_CODE
order by
入院率 desc
,都道府県コード asc;