加载中...
根据score_key并按month查询某列的总和(sum)
<select id="getSumScoresMonth" resultType="Integer">
select sum(score_value)
from score_user_detail
where up_id = #{upId}
and score_type = 1
and user_id = #{userId}
<if test="msgKey!=null">
and score_key in ('studyScores','readScores')
</if>
and DATE_FORMAT(create_time, '%Y-%m') = #{stMonth}
</select>