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