select HOSPITALIZATION.PF_CODE as 都道府県コード
,PREFECTURE.PF_NAME as 都道府県名
,cast((HOSPITALIZATION.INP_YES/(HOSPITALIZATION.INP_YES+HOSPITALIZATION.INP_NO+HOSPITALIZATION.UNIDENTIFIED)) * 10000 AS decimal(10, 2)) as 入院率
from HOSPITALIZATION
join PREFECTURE
on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by 入院率 desc
, 都道府県コード 

select INP_YES/INP_YES as 入院率
from HOSPITALIZATION

select 
HOSPITALIZATION.INP_YES/(HOSPITALIZATION.INP_YES+HOSPITALIZATION.INP_NO+HOSPITALIZATION.UNIDENTIFIED)*1000 as 入院率
from HOSPITALIZATION