select PF_CODE as 都道府県コード,
PF_NAME as 都道府県名,
(select ROUND(INP_YES * 100.0 / (INP_YES + INP_NO + UNIDENTIFIED), 1) from HOSPITALIZATION where HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE) as 入院率
from PREFECTURE where (select count(0) from HOSPITALIZATION where HOSPITALIZATION.PF_CODE = PREFECTURE.PF_CODE) > 0
order by 入院率 desc, PF_CODE asc;