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