SELECT
p.PF_CODE as"都道府県コード",
p.PF_NAME as "都道府県名",
ROUND((CAST(INP_YES AS REAL)/CAST(( INP_YES+ INP_NO + UNIDENTIFIED) AS REAL))*100,1) as "入院率"
FROM HOSPITALIZATION as h
LEFT JOIN PREFECTURE as p on p.PF_CODE = h.PF_CODE
ORDER BY "入院率" desc,h.PF_CODE asc