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