select PF_CODE as 都道府県コード,PF_NAME as 都道府県名, ROUND(100.0*INP_YES/(1.0*(INP_YES+INP_NO+UNIDENTIFIED)),1) as 入院率 
  from (select * from HOSPITALIZATION inner join PREFECTURE on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE ORDER BY HOSPITALIZATION.PF_CODE ASC)
    ORDER BY 入院率 DESC;