$sql = "
    SELECT o.OrderID, o.Time, o.Tax, COUNT(*) AS Products Sold
    FROM `orderentry_ecomm`oe
    JOIN `orders_ecomm`o
    ON oe.OrderID = o.OrderID
    <!--WHERE (in this clause we can have a time limit)-->
    GROUP BY o.OrderID";