SELECT
    PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    CASE WHEN INP_YES+INP_NO+UNIDENTIFIED>0 THEN ROUND(INP_YES*100.0/(INP_YES+INP_NO+UNIDENTIFIED), 1) ELSE 0 END AS 入院率
FROM PREFECTURE LEFT JOIN HOSPITALIZATION USING (PF_CODE) ORDER BY 入院率 DESC, PF_CODE ASC;