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