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