SELECT P.PF_CODE AS "都道府県コード", P.PF_NAME AS "都道府県名", H.INP_YES / H.INP_NO * H.INP_YES * UNIDENTIFIED AS "入院率"
FROM HOSPITALIZATION AS H JOIN PREFECTURE AS P ON H.PF_CODE = P.PF_CODE
ORDER BY "入院率" DESC
;