SELECT
HP.PF_CODE AS "都道府県コード"
,PF.PF_NAME AS "都道府県名"
, ROUND ((CAST(HP.INP_YES AS real) / CAST((HP.INP_YES + HP.INP_NO + UNIDENTIFIED)AS real)) * 100 , 1) AS  "入院率"
FROM
HOSPITALIZATION HP
inner join PREFECTURE PF on PF.PF_CODE = HP.PF_CODE
ORDER BY "入院率" DESC
,"都道府県コード"
;