select
HOSPITALIZATION.PF_CODE as 都道府県コード,
PREFECTURE.PF_NAME as 都道府県名,
--CAST(CAST(INP_YES as decimal(10,2))/CAST(7 as decimal(10,2)) as decimal(10,2))--*(INP_YES+INP_NO+UNIDENTIFIED),
--(INP_YES/(INP_YES+INP_NO+UNIDENTIFIED))*100 as 入院率
ROUND(CAST(INP_YES as real)/CAST(INP_YES+INP_NO+UNIDENTIFIED as real)*100, 1) as 入院率
from HOSPITALIZATION
join PREFECTURE
on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
--order by 入院率 desc, lpad(cast(HOSPITALIZATION.PF_CODE as character varying),5,0)
order by 入院率 desc, SUBSTR(都道府県コード, 6)
--order by 入院率 desc, 都道府県コード desc