select HOSPITALIZATION.PF_CODE as 都道府県コード, PREFECTURE.PF_NAME as 都道府県名, ROUND(INP_YES*100/(INP_YES + INP_NO + UNIDENTIFIED),2) as 入院率
from HOSPITALIZATION
inner join PREFECTURE
on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by 入院率 asc,都道府県コード desc;

-- select HOSPITALIZATION.PF_CODE as 都道府県コード, PREFECTURE.PF_NAME as 都道府県名, ROUND((INP_YES/(INP_YES + INP_NO + UNIDENTIFIED))*100) as 入院率
-- from HOSPITALIZATION
-- innner join PREFECTURE
-- on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
-- order by 入院率 asc,都道府県コード desc;