SELECT
h.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 h
JOIN PREFECTURE p ON h.PF_CODE = p.PF_CODE
ORDER BY 入院率 desc, 都道府県コード asc