GROUP BY

Returns queries in groups

SELECT SALES_DATE, SUM(TOTAL_AMOUNT)
FROM SALES
GROUP BY SALES_DATE;

This will take the sales made on the dates add them and return a column with the date -> total amount