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