SELECT
HT.PF_CODE AS 都道府県コード,
PT.PF_NAME AS 都道府県名, 
ROUND(
CAST(HT.INP_YES AS REAL)/CAST((HT.INP_YES+HT.INP_NO+HT.UNIDENTIFIED) AS REAL)*100,1) AS 入院率
FROM
HOSPITALIZATION AS HT
INNER JOIN PREFECTURE AS PT
ON
HT.PF_CODE = PT.PF_CODE

ORDER BY 入院率 DESC,HT.PF_CODE ASC