select H.PF_CODE AS 都道府県コード, 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
left outer join PREFECTURE AS P
on H.PF_CODE = P.PF_CODE
order BY 入院率 DESC, H.PF_CODE ASC