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