select 
PREFECTURE.PF_CODE as "都道府県コード",
PREFECTURE.PF_NAME as "都道府県名",
(
select  round((cast(INP_YES as REAL) *100) / (cast(INP_YES as REAL)+cast(INP_NO as REAL)+cast(UNIDENTIFIED as REAL)), 1)
from HOSPITALIZATION
where HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
) as "入院率"
from PREFECTURE
order by "入院率" desc, "都道府県コード" asc