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 PREFECTURE AS P INNER JOIN HOSPITALIZATION AS H USING(PF_CODE) ORDER BY 入院率 DESC, 都道府県コード ASC ;