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, '都道府県コード' ASC;