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