SELECT
    pfcd as '都道府県コード',
    pfnm as '都道府県名',
    rate as '入院率'
    FROM (
        SELECT 
          hosp.PF_CODE as pfcd,
          pref.PF_NAME as pfnm,
          round(
            cast(hosp.INP_YES as REAL) / 
            cast(hosp.INP_YES + hosp.INP_NO + hosp.UNIDENTIFIED as REAL)
           * 100, 1) as rate
        FROM HOSPITALIZATION as hosp
        INNER JOIN PREFECTURE as pref ON hosp.PF_CODE == pref.PF_CODE
    )
ORDER BY rate DESC, pfcd ASC