SELECT
 HOSPITALIZATION.PF_CODE AS 都道府県コード,
 PREFECTURE.PF_NAME AS 都道府県名,
  ROUND(HOSPITALIZATION.INP_YES * 100.0 / ( HOSPITALIZATION.INP_YES +  HOSPITALIZATION.INP_NO +  HOSPITALIZATION.UNIDENTIFIED),1) AS 入院率
FROM
 HOSPITALIZATION
INNER JOIN
 PREFECTURE
ON
 PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE
ORDER BY
 入院率 desc,
 都道府県コード asc;