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