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