SELECT 
PREF.PF_CODE AS 都道府県コード,
PREF.PF_NAME AS 都道府県名,
ROUND((CAST(HOSP.INP_YES as REAL)/ (CAST(HOSP.INP_YES as REAL) + CAST(HOSP.INP_NO as REAL) + CAST(HOSP.UNIDENTIFIED as REAL)) * 100),1) AS 入院率
FROM PREFECTURE AS PREF
INNER JOIN HOSPITALIZATION AS HOSP
ON PREF.PF_CODE = HOSP.PF_CODE
ORDER BY 入院率 desc, HOSP.PF_CODE