SELECT PRE.PF_CODE, PRE.PF_NAME, 
round (CAST(HOS.INP_YES AS REAL)/
CAST(HOS.INP_YES+HOS.INP_NO+HOS.UNIDENTIFIED  AS REAL)* 100 , 1) AS PER 







FROM PREFECTURE  AS PRE INNER JOIN HOSPITALIZATION AS HOS ON PRE.PF_CODE = HOS.PF_CODE
ORDER BY PER DESC, PRE.PF_CODE;