SELECT a.PF_CODE as 都道府県コード
      ,a.PF_NAME  as 都道府県名
      ,b.rate as 入院率
FROM PREFECTURE a
inner join (
SELECT ROUND(sum(b.INP_YES) * 100.0 / (sum(b.INP_YES) + sum(b.INP_NO) + sum(b.UNIDENTIFIED)), 1) as rate
      , b.PF_CODE
  FROM HOSPITALIZATION as b
  GROUP BY b.PF_CODE)b
 on a.PF_CODE = b.PF_CODE
ORDER BY  b.rate Desc
         ,a.PF_CODE