SELECT t_01.PF_CODE AS 都道府県コード, t_01.PF_NAME AS 都道府県名, ROUND(100.0*t_02.INP_YES/(t_02.INP_YES*1.0+t_02.INP_NO*1.0+t_02.UNIDENTIFIED*1.0),1) AS 入院率
FROM PREFECTURE AS t_01
INNER JOIN HOSPITALIZATION AS t_02 ON t_01.PF_CODE=t_02.PF_CODE
ORDER BY 入院率 DESC, 都道府県コード