SELECT 
    H.PF_CODE "都道府県コード",
    PF_NAME "都道府県名",
    ROUND(CAST(SUM(INP_YES)*100 as float)/(SUM(INP_YES)+SUM(INP_NO)+SUM(UNIDENTIFIED)),1) "入院率" 
FROM HOSPITALIZATION H 
    JOIN PREFECTURE P
ON H.PF_CODE = P.PF_CODE
GROUP BY H.PF_CODE
ORDER BY "入院率" DESC, H.PF_CODE ASC
;