SELECT PREFECTURE.PF_CODE AS '都道府県コード', PF_NAME AS 都道府県名, ROUND(SUM(INP_YES) * 100.0 / (SUM(INP_YES) + SUM(INP_NO) + SUM(UNIDENTIFIED)), 1)  AS '入院率'
FROM PREFECTURE JOIN HOSPITALIZATION ON PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE GROUP BY PREFECTURE.PF_CODE ORDER BY 3 desc, 1 asc;