There is an orders table with a total column that has more than 1000 records. How I can get the daily sum of total for each day. I mean for Monday, Thursday, Wednesday, …. there are many and different rows, and I want to show the sum of total of each day separately? in UI as:
saturday: 111211,
sunday: 211444,
Monday: 120012000,
Thursday: 1225121,