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