SELECT a.PF_CODE AS '都道府県コード', b.PF_NAME AS '都道府県名', ROUND(CAST(a.INP_YES AS FLOAT)/ CAST(a.INP_YES + a.INP_NO+ a.UNIDENTIFIED as FLOAT)*100, 1)AS '入院率'
FROM HOSPITALIZATION AS a
LEFT OUTER JOIN PREFECTURE as b  on a.PF_CODE = b.PF_CODE
--WHERE a.PF_CODE = b.PF_CODE 
GROUP BY a.PF_CODE
ORDER BY '入院率' DESC, a.PF_CODE