<select id="getTaskStatusCounts" resultMap="taskStatusCountResultMap" parameterType="com.example.model.QueryRequest">
    SELECT
        tt.region_name_en AS region,
        tt.office_name_en AS office,

        CONCAT(
            '{',
            <foreach collection="years" item="year" separator=",">
                <foreach collection="months" item="month" separator=",">
                    CONCAT('"month_${year}_${month}":',
                    COUNT(CASE WHEN SUBSTRING(tt.task_finish_time, 1, 7) = CONCAT(#{year}, '-', #{month}) THEN 1 END))
                </foreach>
            </foreach>,
            '}'
        ) AS monthlyCounts

    FROM
        task_list tt
    <include refid="queryTaskStatusCondition"/>
    GROUP BY
        tt.region_name_en,
        tt.office_name_en
    ORDER BY
        tt.region_name_en ASC;
</select>

<select id="getTaskStatusCounts" resultMap="taskStatusCountResultMap" parameterType="com.example.model.QueryRequest">
    SELECT
        tt.region_name_en AS region,
        tt.office_name_en AS office,

        CONCAT(
            '{',
            <foreach collection="years" item="year" separator=",">
                <foreach collection="months" item="month" separator=",">
                    CONCAT('"month_${year}_${month}":',
                    COUNT(CASE WHEN SUBSTRING(tt.task_finish_time, 1, 7) = CONCAT(#{year}, '-', #{month}) THEN 1 END))
                </foreach>
            </foreach>,
            '}'
        ) AS monthlyCounts

    FROM
        task_list tt
    <include refid="queryTaskStatusCondition"/>
    GROUP BY
        tt.region_name_en,
        tt.office_name_en
    ORDER BY
        tt.region_name_en ASC;
</select>

ause: java.sql.SQLException: Error converting JSON to Map
; uncategorized SQLException; SQL state [null]; error code [0]; Error converting JSON to Map; nested exception is java.sql.SQLException: Error converting JSON to Map] with root cause
com.fasterxml.jackson.core.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate Object entries
 at [Source: (String)"{"month_2022_01":0"month_2022_02":0"month_2022_03":0"month_2023_01":3"month_2023_02":4"month_2023_03":8}"; line: 1, column: 20]

ause: java.sql.SQLException: Error converting JSON to Map
; uncategorized SQLException; SQL state [null]; error code [0]; Error converting JSON to Map; nested exception is java.sql.SQLException: Error converting JSON to Map] with root cause
com.fasterxml.jackson.core.JsonParseException: Unexpected character ('"' (code 34)): was expecting comma to separate Object entries
 at [Source: (String)"{"month_2022_01":0"month_2022_02":0"month_2022_03":0"month_2023_01":3"month_2023_02":4"month_2023_03":8}"; line: 1, column: 20]