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