SELECT
  PF_CODE AS 都道府県コード,
  PF_NAME AS 都道府県名,
  round(CAST(A AS REAL) / CAST(B AS REAL), 1) AS 入院率
FROM (
SELECT
  PF_CODE,
  PF_NAME,
  SUM(INP_YES) * 100 AS A,
  SUM(INP_YES) + SUM(INP_NO) + SUM(UNIDENTIFIED) AS B
FROM HOSPITALIZATION
INNER JOIN PREFECTURE USING (PF_CODE)
GROUP BY PF_CODE, PF_NAME
) X
ORDER BY
  入院率 DESC,
  都道府県コード ASC