How to choose the date of maximum sales?

Question

SQL

Hello!
The task is to find the date of maximum sales. Table:

Now I grouped the sales (query in the screenshot) by dates and got:

Finally, I should get the date 2017-01-02, when the sales are maximum and amount to 1105.
How to do this?

Answer 1

SELECT `date`, SUM( total) AS bablo
FROM  `sale` 
GROUP BY `date`
ORDER BY bablo DESC 
LIMIT 1

Answer 2

You can try like this:

select date, sum(total) as sum 
  from sale 
 group by date
having sum(total) >= all (select sum(total)
                            from sale 
                           group by date)