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