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