SELECT CAST(p.PF_CODE AS INT) AS "都道府県コード", PF_NAME AS "都道府県名", round(((INP_YES * 1.0) / (INP_YES + INP_NO + UNIDENTIFIED) * 1.0) * 100, 1) AS "入院率"
FROM HOSPITALIZATION AS h, PREFECTURE AS p 
WHERE h.PF_CODE = p.PF_CODE
ORDER BY "入院率" DESC, "都道府県コード" ;