SELECT PF_CODE AS '都道府県コード', PF_NAME AS '都道府県名', ROUND( CAST(INP_YES AS REAL) * 100 / (CAST(INP_YES AS REAL) + CAST(INP_NO AS REAL) + CAST(UNIDENTIFIED AS REAL)), 1 ) AS '入院率'
FROM PREFECTURE NATURAL INNER JOIN HOSPITALIZATION
ORDER BY '入院率' DESC, PF_CODE ASC