select a."PF_CODE" as "都道府県コード", a."PF_NAME" as "都道府県名",
case when (b."INP_YES" * 100)  %  (b."INP_YES" + b."INP_NO" + b."UNIDENTIFIED") == 0 then (b."INP_YES" * 100)  /  (b."INP_YES" + b."INP_NO" + b."UNIDENTIFIED")
else round((cast(b."INP_YES" as 'real')) * 100 / (b."INP_YES" + b."INP_NO" + b."UNIDENTIFIED"),1) 
end as "入院率" 
from "PREFECTURE" as a
inner join
"HOSPITALIZATION" as b
on
b."PF_CODE" = a."PF_CODE"
order by "入院率" desc, "都道府県コード" asc