SELECT 
pr.pf_name as '都道府県名',
pr.pf_code as '都道府県コード',
(CASE when 
    CAST(round(
    (hp.inp_yes/CAST(hp.inp_yes+hp.inp_no+hp.unidentified AS FLOAT)), 3)*1000 as INTEGER) LIKE '_0' 
    THEN 
    CAST(round(
    (hp.inp_yes/CAST(hp.inp_yes+hp.inp_no+hp.unidentified AS FLOAT)), 3)*100 as INTEGER)
    ELSE
    round(hp.inp_yes/CAST(hp.inp_yes+hp.inp_no+hp.unidentified AS FLOAT)*100, 1)
    END
)
 as '入院率'
from prefecture pr
join hospitalization hp
on hp.pf_code = pr.pf_code
order by '入院率' desc, pr.pf_code