SELECT
    pf.pf_code AS 都道府県コード,
    pf.pf_name AS 都道府県名,
    ROUND(inp_yes * 100.0 / (inp_yes + inp_no + unidentified), 1) AS 入院率
FROM hospitalization AS hos
JOIN prefecture AS pf
ON hos.pf_code = pf.pf_code
ORDER BY 入院率 DESC, 都道府県コード