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