SELECT 
    h.PF_CODE AS 都道府県コード, 
    PF_NAME AS 都道府県名, 
    ROUND(100. * INP_YES / (INP_YES + INP_NO + UNIDENTIFIED), 1) AS 入院率 

FROM HOSPITALIZATION AS h 
    LEFT OUTER JOIN PREFECTURE AS p 
    ON h.PF_CODE = p.PF_CODE 
ORDER BY 入院率 DESC, 都道府県コード 
;