SELECT DATE(o.created_at) AS order_date,
COUNT(*) AS COUNT,(SELECT SUM(op.price * op.amount) FROM `orderhasproduct` op WHERE op.order_id
                     IN ((SELECT x.order_id FROM `order` x WHERE DATE(x.created_at) = DATE(o.created_at)))) AS sum_price,
                     (SELECT SUM(op.amount) FROM `orderhasproduct` op WHERE op.order_id
                      IN ((SELECT x.order_id FROM `order` x WHERE DATE(x.created_at) = DATE(o.created_at)))) AS sum_amount
                      FROM `order` o  GROUP BY DATE(o.created_at);