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