select PREFECTURE.PF_CODE as 都道府県コード,
       PREFECTURE.PF_NAME as 都道府県名,
       ROUND(cast(INP_YES as real)/cast(INP_YES+INP_NO+UNIDENTIFIED as real)*100,1) as 入院率
  from PREFECTURE LEFT OUTER JOIN HOSPITALIZATION
    on PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE
 order by 3 desc, PREFECTURE.PF_CODE+0 asc