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 h
INNER JOIN PREFECTURE p ON h.PF_CODE = p.PF_CODE
ORDER BY ROUND(CAST(h.INP_YES as REAL)/(CAST(h.INP_YES+h.INP_NO +h.UNIDENTIFIED as REAL))*100,1) DESC, '都道府県コード' ASC