select
  `H`.`PF_CODE` `都道府県コード`,
  `P`.`PF_NAME` `都道府県名`,
  REPLACE(ROUND(`H`.`INP_YES`/CAST(`H`.`INP_YES`+`H`.`INP_NO`+`H`.`UNIDENTIFIED` AS FLOAT)*100,1),'.0','') `入院率`
from `HOSPITALIZATION` `H`
inner join `PREFECTURE` `P` on (
  `H`.`PF_CODE`=`P`.`PF_CODE`
)
order by `入院率` desc, `都道府県コード`
;