SELECT h.pf_code "都道府県コード",
       p.pf_name "都道府県名",
       ROUND(CAST(inp_yes AS REAL) / (inp_yes + inp_no + unidentified) * 100, 1) "入院率"
FROM hospitalization h
INNER JOIN prefecture p
ON h.pf_code = p.pf_code
ORDER BY "入院率" DESC, "都道府県コード" ASC;