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