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