SELECT P.PF_CODE AS "都道府県コード", P.PF_NAME AS "都道府県名", 
ROUND(CAST(H.INP_YES*100 AS REAL)/CAST((H.INP_YES+H.INP_NO+UNIDENTIFIED) AS REAL), 1) AS "入院率"
FROM PREFECTURE AS P INNER JOIN HOSPITALIZATION AS H ON H.PF_CODE = P.PF_CODE ORDER BY "入院率" DESC, "都道府県コード";