select
PREFECTURE.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", 
round(cast(INP_YES as REAL) *100 / cast((INP_YES  + INP_NO + UNIDENTIFIED) as REAL) ,1)as "入院率"
FROM HOSPITALIZATION
LEFT JOIN PREFECTURE
on HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE
order by 3 desc, 1 asc