SELECT prefecture.pf_code as 都道府県コード, prefecture.pf_name as 都道府県名, 
ROUND(((CAST(INP_YES as real) / CAST((INP_YES + INP_NO + UNIDENTIFIED)as real))*100),1) as 入院率
FROM hospitalization
LEFT JOIN prefecture
ON hospitalization.pf_code = prefecture.pf_code
ORDER BY 入院率 DESC, prefecture.pf_code asc;