SELECT
      HOSPITALIZATION.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
    INNER JOIN PREFECTURE
        ON PREFECTURE.PF_CODE = HOSPITALIZATION.PF_CODE


ORDER BY
      入院率 desc
    , 都道府県コード asc
;