SELECT
    pf_code AS 都道府県コード,
    pf_name AS 都道府県名,
    ROUND(CAST(inp_yes AS REAL) / CAST((inp_yes + inp_no + unidentified) AS REAL) * 100, 1) AS 入院率
FROM hospitalization
LEFT OUTER JOIN prefecture USING (pf_code)
ORDER BY 入院率 DESC, pf_code ASC;