SELECT 
    PREFECTURE.PF_CODE AS 都道府県コード, 
    PF_NAME AS 都道府県名, 
    ROUND(INP_YES * 100.0 / (INP_YES + INP_NO + UNIDENTIFIED), 2)  AS 入院率
FROM PREFECTURE JOIN HOSPITALIZATION ON PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE 
ORDER BY 入院率 desc, 都道府県コード asc;