select 
 p.PF_CODE as "都道府県コード"
,p.PF_NAME as "都道府県名"
,ifnull(round(cast(h.INP_YES as real)/cast((h.INP_YES+h.INP_NO+h.UNIDENTIFIED) as real)*100,1),0) as "入院率"
from PREFECTURE p
inner join  HOSPITALIZATION h
    on p.PF_CODE = h.PF_CODE
order by
 ifnull(round(cast(h.INP_YES as real)/cast((h.INP_YES+h.INP_NO+h.UNIDENTIFIED) as real)*100,1),0) desc
,p.PF_CODE asc