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