SELECT
    H.PF_CODE AS '都道府県コード',
    P.PF_NAME AS '都道府県名',
    CASE
        WHEN round((cast(H.INP_YES AS REAL) / (cast(H.INP_YES AS REAL) + cast(H.INP_NO AS REAL) + cast(H.UNIDENTIFIED AS REAL)) * 100) ,0) = 
             round((cast(H.INP_YES AS REAL) / (cast(H.INP_YES AS REAL) + cast(H.INP_NO AS REAL) + cast(H.UNIDENTIFIED AS REAL)) * 100) ,1) THEN
             round((cast(H.INP_YES AS REAL) / (cast(H.INP_YES AS REAL) + cast(H.INP_NO AS REAL) + cast(H.UNIDENTIFIED AS REAL)) * 100) ,0)
        ELSE round((cast(H.INP_YES AS REAL) / (cast(H.INP_YES AS REAL) + cast(H.INP_NO AS REAL) + cast(H.UNIDENTIFIED AS REAL)) * 100) ,1)
    END AS '入居率'
FROM `HOSPITALIZATION` H
JOIN `PREFECTURE` P
ON H.PF_CODE = P.PF_CODE
ORDER BY '入院率' DESC, '都道府県コード'
;