select HOSPITALIZATION.PF_CODE AS 都道府県コード
,PREFECTURE.PF_NAME AS 道府県名
,round( ( cast(HOSPITALIZATION.INP_YES AS REAL) / cast((HOSPITALIZATION.INP_YES + HOSPITALIZATION.INP_NO + HOSPITALIZATION.UNIDENTIFIED) AS REAL)) * 100 , 1)AS 入院率
from HOSPITALIZATION
inner join PREFECTURE
on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by 入院率 DESC,PREFECTURE.PF_CODE ASC