select PREFECTURE.PF_CODE as 都道府県コード
    , PF_NAME as 都道府県名
    , ROUND(CAST(INP_YES AS REAL)/CAST(INP_YES+INP_NO+UNIDENTIFIED AS REAL)*100,1) as 入院率
from HOSPITALIZATION inner join PREFECTURE 
where HOSPITALIZATION.PF_CODE=PREFECTURE.PF_CODE
order by INP_YES desc, PREFECTURE.PF_CODE asc;