2 Report the total number of items sold per order in sql que

2 Report the total number of items sold per order in sql query

Solution

Hi friend, you have not posted the details of Schema.

But based on the question, i am giving you a query(idea)

You need to use GROUP BY on day column of table

selct day, count(items)
from products
group by day

Please try to post all details