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