我的表名是HaveGoal。我有一个包含列的表:id、week、goals我想要一个查询,该查询对具有相同id的所有目标求和,并在表中给出数字及其总目标
总目标:
SELECT id, SUM(goals), COUNT(goals)
FROM HaveGoal
GROUP BY id
每周总目标:
SELECT id, week, SUM(goals), COUNT(goals)
FROM HaveGoal
GROUP BY id, week