SELECT PF_CODE AS "都道府県コード",PF_NAME AS "都道府県名",rate AS "入院率"
FROM(SELECT PF_CODE, PF_NAME, round(cast(INP_YES as REAL) / cast((INP_YES+INP_NO+UNIDENTIFIED) as REAL) * 100, 1) as rate
    FROM (SELECT * FROM HOSPITALIZATION h JOIN PREFECTURE p WHERE h.PF_CODE = p.PF_CODE)
    ORDER BY rate DESC, PF_CODE ASC)