Suppose you have a table named “Orders” with columns “OrderID”, “ProductID”, and “OrderDate”. Write an SQL query to find orders for the same product that were placed on the same day.
Select count(orderid) as Orders, productid, orderdate from orders Group by productid, orderdate