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




--入院率の降順
--都道府県コードの昇順