SELECT
 a.PF_CODE as "都道府県コード",
 b.PF_NAME as "都道府県名",
 ROUND(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED)*100) as "入院率"
 FROM HOSPITALIZATION a,PREFECTURE b
 WHERE
  a.PF_CODE = b.PF_CODE
 order by "入院率" desc,a.PF_CODE