SELECT PF_CODE as "都道府県コード", PF_NAME as "都道府県名", round(INP_YES *100.0 / s, 1) as "入院率"
FROM (
    SELECT P.PF_CODE, PF_NAME, INP_YES, INP_YES+ INP_NO+ UNIDENTIFIED as s
    FROM HOSPITALIZATION as H
    INNER JOIN PREFECTURE as P ON H.PF_CODE = P.PF_CODE 
    )
ORDER BY "入院率" desc, "都道府県コード"