select
    T1.PF_CODE as 都道府県コード,
    T1.PF_NAME as 都道府県名,
    round(100*T2.INP_YES/(T2.INP_YES + T2.INP_NO+  T2.UNIDENTIFIED),2) as 入院率
from
     PREFECTURE T1 LEFT OUTER JOIN HOSPITALIZATION T2 ON T1.PF_CODE = T2.PF_CODE
order by
    入院率 desc, T1.PF_CODE;