score:2

Accepted answer

you can use the SUM() function in combination with GROUP BY:

SELECT date, SUM(number) FROM table GROUP BY date;

Related Articles