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